APPS.PAY_IN_REPORTS_PKG dependencies on PER_ASSIGNMENTS_F

Line 47: ,per_assignments_f pea-- Done this for bug 4774018

43: AND aei_information1 = p_period
44: AND information_type = DECODE(p_report_type,'PF','PER_IN_PF_REMARKS','ESI','PER_IN_ESI_REMARKS')
45: AND assignment_id IN(SELECT DISTINCT pea.assignment_id
46: FROM per_people_f pep -- Reduced cost from 2294 to 69
47: ,per_assignments_f pea-- Done this for bug 4774018
48: WHERE pep.person_id = pea.person_id
49: AND pep.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
50: AND p_number = DECODE(p_report_type,'PF'
51: ,pep.per_information8

Line 1188: ,per_assignments_f asg

1184: AND action_information3 = p_gre_org_id
1185: AND action_context_id IN ( SELECT MAX(action_context_id)
1186: FROM pay_action_information pai
1187: ,pay_assignment_actions paa
1188: ,per_assignments_f asg
1189: WHERE pai.action_information_category = 'IN_EOY_PERSON'
1190: AND pai.action_context_type = 'AAP'
1191: AND pai.action_information2 = p_assess_year
1192: AND pai.action_information3 = p_gre_org_id

Line 1214: ,per_assignments_f asg

1210: SELECT MAX(pai.action_context_id) action_cont_id
1211: ,source_id sour_id
1212: FROM pay_action_information pai
1213: ,pay_assignment_actions paa
1214: ,per_assignments_f asg
1215: WHERE pai.action_information_category = 'IN_EOY_PERSON'
1216: AND pai.action_information3 = p_gre_org_id
1217: AND pai.action_information2 = p_assess_year
1218: AND pai.assignment_id = asg.assignment_id

Line 2653: per_assignments_f paf

2649: /*Cursor to get the disable proof details */
2650: CURSOR c_disable_proof is
2651: SELECT pdf.dis_information1
2652: FROM per_disabilities_f pdf,
2653: per_assignments_f paf
2654: WHERE paf.assignment_id = p_assignment_id
2655: AND paf.person_id = pdf.person_id
2656: AND p_earn_date BETWEEN paf.effective_start_date AND paf.effective_end_date
2657: AND p_earn_date BETWEEN pdf.effective_start_date AND pdf.effective_end_date;

Line 2663: FROM per_assignments_f assign,

2659:
2660: /*Cursor to get the employer classification details */
2661: CURSOR c_emplr_class is
2662: SELECT target.org_information3
2663: FROM per_assignments_f assign,
2664: hr_soft_coding_keyflex scl,
2665: hr_organization_information target
2666: WHERE assign.assignment_id = p_assignment_id
2667: AND p_earn_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date

Line 2675: FROM per_assignments_f assign,

2671:
2672: /*cursor to get the hire date details */
2673: CURSOR c_hire_date is
2674: SELECT service.date_start
2675: FROM per_assignments_f assign,
2676: per_periods_of_service service
2677: WHERE p_earn_date BETWEEN ASSIGN.effective_start_date AND assign.effective_end_date
2678: AND assign.assignment_id = p_assignment_id
2679: AND service.period_of_service_id (+)= assign.period_of_service_id;

Line 2825: FROM per_assignments_f pea

2821: CURSOR c_final_check(p_pf_org_id NUMBER
2822: ,p_payroll_date DATE)
2823: IS
2824: SELECT 1 -- Modified for bug 4774108
2825: FROM per_assignments_f pea
2826: ,hr_soft_coding_keyflex hrscf
2827: ,per_people_f pep
2828: WHERE pea.person_id = pep.person_id
2829: AND pep.per_information8 = p_pf_number

Line 4937: FROM per_assignments_f pea--Modified for bug 4774108

4933: CURSOR c_final_check(p_esi_org_id NUMBER
4934: ,p_payroll_date DATE)
4935: IS
4936: SELECT 1
4937: FROM per_assignments_f pea--Modified for bug 4774108
4938: ,per_people_f pep
4939: ,hr_soft_coding_keyflex hrscf
4940: WHERE pea.person_id = pep.person_id
4941: AND pep.per_information9 = p_insurance_no