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 1108: ,per_assignments_f asg

1104: AND action_information3 = p_gre_org_id
1105: AND action_context_id IN ( SELECT MAX(action_context_id)
1106: FROM pay_action_information pai
1107: ,pay_assignment_actions paa
1108: ,per_assignments_f asg
1109: WHERE pai.action_information_category = 'IN_EOY_PERSON'
1110: AND pai.action_context_type = 'AAP'
1111: AND pai.action_information2 = p_assess_year
1112: AND pai.action_information3 = p_gre_org_id

Line 1134: ,per_assignments_f asg

1130: SELECT MAX(pai.action_context_id) action_cont_id
1131: ,source_id sour_id
1132: FROM pay_action_information pai
1133: ,pay_assignment_actions paa
1134: ,per_assignments_f asg
1135: WHERE pai.action_information_category = 'IN_EOY_PERSON'
1136: AND pai.action_information3 = p_gre_org_id
1137: AND pai.action_information2 = p_assess_year
1138: AND pai.assignment_id = asg.assignment_id

Line 2072: per_assignments_f paf

2068: /*Cursor to get the disable proof details */
2069: CURSOR c_disable_proof is
2070: SELECT pdf.dis_information1
2071: FROM per_disabilities_f pdf,
2072: per_assignments_f paf
2073: WHERE paf.assignment_id = p_assignment_id
2074: AND paf.person_id = pdf.person_id
2075: AND p_earn_date BETWEEN paf.effective_start_date AND paf.effective_end_date
2076: AND p_earn_date BETWEEN pdf.effective_start_date AND pdf.effective_end_date;

Line 2082: FROM per_assignments_f assign,

2078:
2079: /*Cursor to get the employer classification details */
2080: CURSOR c_emplr_class is
2081: SELECT target.org_information3
2082: FROM per_assignments_f assign,
2083: hr_soft_coding_keyflex scl,
2084: hr_organization_information target
2085: WHERE assign.assignment_id = p_assignment_id
2086: AND p_earn_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date

Line 2094: FROM per_assignments_f assign,

2090:
2091: /*cursor to get the hire date details */
2092: CURSOR c_hire_date is
2093: SELECT service.date_start
2094: FROM per_assignments_f assign,
2095: per_periods_of_service service
2096: WHERE p_earn_date BETWEEN ASSIGN.effective_start_date AND assign.effective_end_date
2097: AND assign.assignment_id = p_assignment_id
2098: AND service.period_of_service_id (+)= assign.period_of_service_id;

Line 2244: FROM per_assignments_f pea

2240: CURSOR c_final_check(p_pf_org_id NUMBER
2241: ,p_payroll_date DATE)
2242: IS
2243: SELECT 1 -- Modified for bug 4774108
2244: FROM per_assignments_f pea
2245: ,hr_soft_coding_keyflex hrscf
2246: ,per_people_f pep
2247: WHERE pea.person_id = pep.person_id
2248: AND pep.per_information8 = p_pf_number

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

4214: CURSOR c_final_check(p_esi_org_id NUMBER
4215: ,p_payroll_date DATE)
4216: IS
4217: SELECT 1
4218: FROM per_assignments_f pea--Modified for bug 4774108
4219: ,per_people_f pep
4220: ,hr_soft_coding_keyflex hrscf
4221: WHERE pea.person_id = pep.person_id
4222: AND pep.per_information9 = p_insurance_no