APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 376: pay_all_payrolls_f PPY,

372: cp_report_type varchar2,
373: cp_pre_id number) is
374: SELECT DISTINCT ASG.assignment_id ass_id
375: FROM per_all_assignments_f ASG,
376: pay_all_payrolls_f PPY,
377: hr_soft_coding_keyflex SCL
378: WHERE ASG.business_group_id + 0 = cp_bus_grp
379: AND ASG.assignment_type = 'E'
380: AND ASG.effective_start_date <= add_months(cp_effective_date, 12) - 1

Line 424: pay_all_payrolls_f PPY,

420: cp_report_type varchar2,
421: cp_pre_id number) is
422: SELECT DISTINCT ASG.assignment_id ass_id
423: FROM per_all_assignments_f ASG,
424: pay_all_payrolls_f PPY,
425: hr_soft_coding_keyflex SCL
426: WHERE ASG.business_group_id + 0 = cp_bus_grp
427: AND ASG.assignment_type = 'E'
428: AND ASG.effective_start_date <= add_months(cp_effective_date, 12) - 1

Line 470: pay_all_payrolls_f ppf

466: pay_run_result_values prrv,
467: pay_input_values_f piv,
468: pay_assignment_actions paa,
469: pay_payroll_actions ppa,
470: pay_all_payrolls_f ppf
471: WHERE ppa.business_group_id+0 = cp_business_group
472: AND paa.assignment_id = cp_assignment_id
473: AND paa.tax_unit_id = cp_tax_unit_id
474: AND prr.assignment_action_id = paa.assignment_action_id