APPS.PER_ASG_AGGR dependencies on PAY_PAYROLL_ACTIONS

Line 431: FROM pay_payroll_actions ppa,

427: --Cursor to fetch the count of Payroll Actions preformed between the date range specified by NI flag status criteria
428: CURSOR csr_ni_agg_ass
429: IS
430: SELECT COUNT(distinct(paa.assignment_id))
431: FROM pay_payroll_actions ppa,
432: pay_assignment_actions paact,
433: per_all_assignments_f paa
434: WHERE paa.person_id = p_person_id
435: AND paa.assignment_id =paact.assignment_id

Line 600: pay_payroll_actions ppa,

596: CURSOR csr_ear_lat_tax_year(c_assignment_id in number,c_start_date date, c_end_date date) IS
597: select min(ppa.effective_date),
598: max(ppa.effective_date)
599: from pay_assignment_actions paa,
600: pay_payroll_actions ppa,
601: per_all_assignments_f paaf
602: where paa.assignment_id = c_assignment_id
603: and paaf.assignment_id = c_assignment_id
604: and paa.payroll_action_id = ppa.payroll_action_id

Line 1108: FROM pay_payroll_actions ppa,

1104: --Cursor to fetch the count of Payroll Actions preformed between the date range specified by NI flag status criteria
1105: CURSOR csr_ni_agg_ass(p_effective_start_date date, p_effective_end_date date)
1106: IS
1107: SELECT COUNT(distinct(paa.assignment_id))
1108: FROM pay_payroll_actions ppa,
1109: pay_assignment_actions paact,
1110: per_all_assignments_f paa
1111: WHERE paa.person_id = p_person_id
1112: AND paa.assignment_id =paact.assignment_id

Line 2060: from pay_payroll_actions ppa,

2056: cursor check_processed(p_assignment_id number,l_business_group_id number)
2057: is
2058: select 'Y' from dual
2059: where exists (select *
2060: from pay_payroll_actions ppa,
2061: pay_assignment_actions paa
2062: where ppa.report_type in ('RTI_EAS_REP','RTI_EAS_REP_13','RTI_FPS_REP','RTI_FPS_REP_13')
2063: and ppa.action_status = 'C'
2064: and ppa.business_group_id = l_business_group_id