APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 18: g_payroll_id pay_payrolls_f.payroll_id%TYPE;

14: g_archive_pact NUMBER;
15:
16: g_package VARCHAR2(100);
17:
18: g_payroll_id pay_payrolls_f.payroll_id%TYPE;
19: g_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
20: g_business_group_id per_people_f.business_group_id%TYPE;
21: g_financial_year DATE;
22: g_processing_mode VARCHAR2(1);

Line 412: , pay_payrolls_f ppf

408: FROM pay_payroll_actions ppa
409: , per_time_periods ptp
410: , pay_assignment_actions paa
411: , per_assignments_f paf
412: , pay_payrolls_f ppf
413: WHERE paa.assignment_id = paf.assignment_id
414: AND paa.payroll_action_id = ppa.payroll_action_id
415: AND ppa.action_type IN ('R', 'Q')
416: AND ptp.time_period_id = ppa.time_period_id

Line 976: pay_payrolls_f payroll,

972: ,period_types.number_per_fiscal_year total_periods
973: FROM per_people_f person,
974: per_assignments_f assignment,
975: per_periods_of_service service,
976: pay_payrolls_f payroll,
977: per_time_period_types period_types,
978: pay_assignment_actions actions
979: WHERE person.business_group_id = c_business_group_id
980: AND actions.assignment_action_id = c_assignment_action_id