DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 11: g_param_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

7: --
8: -- Parameters to the process - g_payroll_action_id is the cache context
9: --
10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
11: g_param_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
12: g_param_assignment_id per_all_assignments_f.assignment_id%TYPE;
13: g_param_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
14: g_param_business_group_id per_business_Groups.business_group_id%TYPE;
15: g_param_start_date date;

Line 588: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

584: --
585: l_establishment_id pay_assignment_actions.tax_unit_id%TYPE;
586: l_person_id per_all_people_f.person_id%TYPE;
587: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
588: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
589: l_latest_assignment_action_id pay_assignment_actions.assignment_id%TYPE;
590: l_latest_date_paid date;
591: l_ee_asat_date date;
592: l_total_gross_pay number;

Line 1215: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

1211: --
1212: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1213: l_person_id per_all_people_f.person_id%TYPE;
1214: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1215: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
1216: --
1217: l_proc VARCHAR2(40):= g_package||' get_instance_variables ';
1218: cursor csr_establishment(p_paa_id number) is
1219: select paa.tax_unit_id, paa.assignment_id, asg.person_id, asg.payroll_id