APPS.PAY_IN_EOY_REPORTS dependencies on PER_ASSIGNMENTS_F

Line 505: ,per_assignments_f paf

501: cursor csr_action_id is
502: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
503: FROM pay_assignment_actions paa
504: ,pay_payroll_actions ppa
505: ,per_assignments_f paf
506: WHERE paf.assignment_id = paa.assignment_id
507: AND paf.assignment_id = p_assignment_id
508: AND paa.tax_unit_id = p_tax_unit_id
509: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1253: FROM per_assignments_f assign

1249: CURSOR emp_challan_details IS
1250: SELECT input.name name
1251: ,value.screen_entry_value value
1252: , entries.element_entry_id
1253: FROM per_assignments_f assign
1254: ,pay_element_entries_f entries
1255: ,pay_element_types_f type
1256: ,pay_input_values_f input
1257: ,pay_element_entry_values_f value

Line 1843: FROM per_Assignments_f paa,-- Modified this for 4774108 to remove NMV

1839: write_tag('TOTAL',l_tax_in_words );
1840:
1841: SELECT nvl(pps.actual_termination_date,paa.effective_end_Date)
1842: INTO l_asg_end_date
1843: FROM per_Assignments_f paa,-- Modified this for 4774108 to remove NMV
1844: per_periods_of_Service pps
1845: WHERE paa.assignment_id = l_assignment_id
1846: AND paa.period_of_service_id =pps.period_of_service_id
1847: AND paa.effective_end_date = ( SELECT MAX (b.effective_end_date)

Line 2336: ,per_assignments_f asg

2332: SELECT MAX(pai.action_context_id) action_context_id
2333: , pai.action_information17 start_date
2334: , pai.action_information1 employee_number
2335: FROM pay_action_information pai
2336: ,per_assignments_f asg
2337: WHERE pai.action_information_category = 'IN_EOY_PERSON'
2338: AND asg.assignment_id = pai.assignment_id
2339: AND asg.business_group_id = p_business_group_id
2340: AND pai.action_information3 = to_char(p_gre_id) /*Bug 13564801 */

Line 2593: ,per_assignments_f asg

2589: SELECT MAX(pai.action_context_id) action_context_id
2590: , pai.action_information17 start_date
2591: , pai.action_information1 employee_number
2592: FROM pay_action_information pai
2593: ,per_assignments_f asg
2594: WHERE pai.action_information_category = 'IN_EOY_PERSON'
2595: AND asg.assignment_id = pai.assignment_id
2596: AND asg.business_group_id = p_business_group_id
2597: AND pai.action_information3 = to_char(p_gre_id) /*Bug 13564801 */