eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CN_EXT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1013: FROM per_all_assignments_f paa

1009: IS
1010: --
1011: SELECT pap.per_information8 exp_indicator
1012: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer
1013: FROM per_all_assignments_f paa
1014: ,per_all_people_f pap
1015: ,hr_soft_coding_keyflex hsck
1016: WHERE paa.assignment_id = p_assignment_id
1017: AND paa.business_group_id = p_business_group_id

Line 1243: FROM per_all_assignments_f paa

1239: IS
1240: --
1241: SELECT pap.per_information8 exp_indicator
1242: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer
1243: FROM per_all_assignments_f paa
1244: ,per_all_people_f pap
1245: ,hr_soft_coding_keyflex hsck
1246: WHERE paa.assignment_id = p_assignment_id
1247: AND paa.business_group_id = p_business_group_id

Line 1548: FROM per_all_assignments_f paa

1544: IS
1545: --
1546: SELECT pap.per_information8 exp_indicator
1547: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer
1548: FROM per_all_assignments_f paa
1549: ,per_all_people_f pap
1550: ,hr_soft_coding_keyflex hsck
1551: WHERE paa.assignment_id = p_assignment_id
1552: AND paa.business_group_id = p_business_group_id

Line 2281: FROM per_all_assignments_f paa

2277: CURSOR csr_ethnic_group
2278: IS
2279: --
2280: SELECT hr_general.decode_lookup('CN_RACE',pap.per_information17)
2281: FROM per_all_assignments_f paa
2282: ,per_all_people_f pap
2283: WHERE paa.assignment_id = p_assignment_id
2284: AND pap.person_id = paa.person_id
2285: AND p_date_earned BETWEEN paa.effective_start_date

Line 2298: FROM per_all_assignments_f paa

2294: CURSOR csr_hukou_type
2295: IS
2296: --
2297: SELECT hr_general.decode_lookup('CN_HUKOU_TYPE',pap.per_information4 )
2298: FROM per_all_assignments_f paa
2299: ,per_all_people_f pap
2300: WHERE paa.assignment_id = p_assignment_id
2301: AND pap.person_id = paa.person_id
2302: AND p_date_earned BETWEEN paa.effective_start_date

Line 2314: FROM per_all_assignments_f paa

2310: CURSOR csr_work_life_start_date
2311: IS
2312: --
2313: SELECT ppei.pei_information2 Work_Life_Start_Date
2314: FROM per_all_assignments_f paa
2315: ,per_all_people_f pap
2316: ,per_people_extra_info ppei
2317: WHERE paa.assignment_id = p_assignment_id
2318: AND pap.person_id = paa.person_id

Line 2333: FROM per_all_assignments_f paa

2329: CURSOR csr_job_category
2330: IS
2331: --
2332: SELECT hr_general.decode_lookup('JOB_CATEGORIES', pjei.jei_information1)
2333: FROM per_all_assignments_f paa
2334: ,per_job_extra_info pjei
2335: WHERE paa.assignment_id = p_assignment_id
2336: AND pjei.job_id = paa.job_id
2337: AND information_type = 'Job Category'

Line 2628: , per_all_assignments_f paf

2624: --
2625: SELECT max(paa.assignment_action_id)
2626: FROM pay_assignment_actions paa
2627: , pay_payroll_actions ppa
2628: , per_all_assignments_f paf
2629: WHERE paa.payroll_action_id = ppa.payroll_action_id
2630: AND paf.assignment_id = p_assignment_id
2631: AND paf.assignment_id = paa.assignment_id
2632: AND paa.action_status = 'C'

Line 2861: ,per_all_assignments_f paa

2857: SELECT COUNT(*)
2858: FROM pay_element_entries_f pee
2859: ,pay_element_links_f pel
2860: ,pay_element_types_f pet
2861: ,per_all_assignments_f paa
2862: WHERE paa.assignment_id = p_assignment_id
2863: AND paa.business_group_id = p_business_group_id
2864: AND p_effective_date BETWEEN paa.effective_start_date
2865: AND paa.effective_end_date

Line 2972: FROM per_all_assignments_f assign

2968: , p_assignment_id IN NUMBER
2969: , p_date_earned IN DATE
2970: ) IS
2971: SELECT target.ENTRY_INFORMATION1
2972: FROM per_all_assignments_f assign
2973: ,pay_element_entries_f target
2974: ,pay_element_links_f link
2975: ,pay_element_types_f type
2976: WHERE assign.assignment_id = p_assignment_id

Line 3075: , per_all_assignments_f paf

3071: IS
3072: SELECT max(paa.assignment_action_id)
3073: FROM pay_assignment_actions paa
3074: , pay_payroll_actions ppa
3075: , per_all_assignments_f paf
3076: WHERE paa.payroll_action_id = ppa.payroll_action_id
3077: AND paf.assignment_id = p_assignment_id
3078: AND paf.assignment_id = paa.assignment_id
3079: AND paa.action_status = 'C'