DBA Data[Home] [Help]

APPS.PQP_EXPREPLOD_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;

13: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
14: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
15: l_effective_date pay_payroll_actions.effective_date%TYPE ;
16: l_action_type pay_payroll_actions.action_type%TYPE ;
17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
19: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
20: l_gre_name hr_organization_units.name%TYPE ;
21: l_organization_id hr_organization_units.organization_id%TYPE ;

Line 18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;

14: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
15: l_effective_date pay_payroll_actions.effective_date%TYPE ;
16: l_action_type pay_payroll_actions.action_type%TYPE ;
17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
19: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
20: l_gre_name hr_organization_units.name%TYPE ;
21: l_organization_id hr_organization_units.organization_id%TYPE ;
22: l_org_name hr_organization_units.name%TYPE ;

Line 25: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;

21: l_organization_id hr_organization_units.organization_id%TYPE ;
22: l_org_name hr_organization_units.name%TYPE ;
23: l_location_id hr_locations.location_id%TYPE ;
24: l_location_code hr_locations.location_code%TYPE ;
25: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
26: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;
27: l_leg_start_date DATE ;
28: l_leg_end_date DATE ;
29: t_payroll_id NUMBER(15) ;

Line 1021: pay_assignment_actions paa1,

1017: FROM
1018: hr_organization_units hou1,
1019: per_assignments_f paf,
1020: pay_payroll_actions ppa,
1021: pay_assignment_actions paa1,
1022: pay_action_interlocks pai,
1023: pay_assignment_actions paa,
1024: pay_payroll_actions ppa_arch
1025: WHERE paa.assignment_action_id = l_pactid

Line 1023: pay_assignment_actions paa,

1019: per_assignments_f paf,
1020: pay_payroll_actions ppa,
1021: pay_assignment_actions paa1,
1022: pay_action_interlocks pai,
1023: pay_assignment_actions paa,
1024: pay_payroll_actions ppa_arch
1025: WHERE paa.assignment_action_id = l_pactid
1026: AND paa.payroll_action_id = ppa_arch.payroll_action_id
1027: AND pai.locking_action_id = paa.assignment_action_id