APPS.PAY_NZ_EXC dependencies on PAY_PAYROLL_ACTIONS

Line 69: , pay_payroll_actions ppa

65: CURSOR csr_get_business_group
66: IS
67: SELECT ppa.business_group_id
68: FROM pay_assignment_actions paa
69: , pay_payroll_actions ppa
70: WHERE paa.assignment_action_id = p_user_assignment_action_id
71: AND ppa.payroll_action_id = paa.payroll_action_id;
72:
73: --

Line 85: l_business_group_id pay_payroll_actions.business_group_id%type;

81: l_date_dd_mm varchar2(11);
82: l_fy_user_span_start date;
83: l_frequency number;
84: l_dimension_name pay_balance_dimensions.dimension_name%type ;
85: l_business_group_id pay_payroll_actions.business_group_id%type;
86: --
87: begin
88:
89: l_dimension_name := upper(p_dimension_name);

Line 174: pay_payroll_actions pact

170: having the payroll action id */
171: cursor csr_end_date is
172: select PTP.end_date
173: from per_time_periods ptp,
174: pay_payroll_actions pact
175: where pact.payroll_action_id = p_payroll_action_id
176: and pact.payroll_id = ptp.payroll_id
177: and p_given_date between ptp.start_date and ptp.end_date;
178:

Line 293: from pay_payroll_actions PACT,

289: l_dimension_name pay_balance_dimensions.dimension_name%type ;
290:
291: cursor get_beg_of_fiscal_year(c_owner_payroll_action_id number) is
292: select fnd_date.canonical_to_date(org_information11)
293: from pay_payroll_actions PACT,
294: hr_organization_information HOI
295: where UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
296: and HOI.organization_id = PACT.business_group_id
297: and PACT.payroll_action_id = c_owner_payroll_action_id;