APPS.PAY_NZ_EXC dependencies on PAY_PAYROLL_ACTIONS

Line 71: , pay_payroll_actions ppa

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

Line 87: l_business_group_id pay_payroll_actions.business_group_id%type;

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

Line 176: pay_payroll_actions pact

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

Line 295: from pay_payroll_actions PACT,

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