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_IN_24QC_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 1068: ,per_assignments_f asg

1064: ,pep.effective_end_date
1065: FROM pay_action_information pai
1066: ,pay_assignment_actions paa
1067: ,per_people_f pep
1068: ,per_assignments_f asg
1069: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
1070: AND pai.action_context_id = paa.assignment_action_id
1071: AND pai.action_information3 = g_gre_id
1072: AND paa.payroll_action_id = p_payroll_action_id

Line 1081: ,per_assignments_f paa

1077: AND (
1078: (
1079: (NVL(pai.action_information13,'0') <> (SELECT NVL(paei.aei_information2,'0')
1080: FROM per_assignment_extra_info paei
1081: ,per_assignments_f paa
1082: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1083: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1084: AND paei.assignment_id = paa.assignment_id
1085: AND paa.assignment_id = asg.assignment_id

Line 1163: ,per_assignments_f asg

1159: IS
1160: SELECT pai.action_context_id
1161: FROM pay_action_information pai
1162: ,per_people_f pep
1163: ,per_assignments_f asg
1164: ,pay_assignment_actions paa
1165: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1166: AND paa.assignment_action_id = pai.action_context_id
1167: AND pai.source_id = p_element_entry_id

Line 1188: ,per_assignments_f paa

1184: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1185: AND (
1186: (NVL(pai.action_information18,'0') <> (SELECT NVL(paei.aei_information2,'0')
1187: FROM per_assignment_extra_info paei
1188: ,per_assignments_f paa
1189: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1190: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1191: AND paei.assignment_id = paa.assignment_id
1192: AND paa.assignment_id = asg.assignment_id

Line 1233: ,per_assignments_f asg

1229: (
1230: SELECT 1
1231: FROM pay_action_information pai
1232: ,per_people_f pep
1233: ,per_assignments_f asg
1234: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1235: AND pai.source_id = p_element_entry_id
1236: AND pai.action_information3 = g_gre_id
1237: AND pai.action_context_id = p_assignment_action_id

Line 1245: ,per_assignments_f paa

1241: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1242: AND (
1243: (NVL(pai.action_information18,'0') = (SELECT NVL(paei.aei_information2,'0')
1244: FROM per_assignment_extra_info paei
1245: ,per_assignments_f paa
1246: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1247: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1248: AND paei.assignment_id = paa.assignment_id
1249: AND paa.assignment_id = asg.assignment_id

Line 1367: FROM per_assignments_f

1363:
1364: CURSOR c_bg_check(p_assignment_id NUMBER)
1365: IS
1366: SELECT 1
1367: FROM per_assignments_f
1368: WHERE business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1369: AND assignment_id = p_assignment_id;
1370:
1371: l_procedure VARCHAR2(100);

Line 1766: ,per_assignments_f paf

1762: SELECT
1763: paa.assignment_action_id run_asg_action_id
1764: FROM pay_assignment_actions paa
1765: ,pay_payroll_actions ppa
1766: ,per_assignments_f paf
1767: WHERE paf.assignment_id = paa.assignment_id
1768: AND paa.assignment_id = pai.assignment_id
1769: AND paa.tax_unit_id = pai.action_information3
1770: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1830: ,per_assignments_f paf

1826: ,paf.assignment_id assignment_id
1827: ,NULL last_action_context_id
1828: FROM pay_assignment_actions paa
1829: ,pay_payroll_actions ppa
1830: ,per_assignments_f paf
1831: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
1832: AND paf.assignment_id = paa.assignment_id
1833: AND paa.tax_unit_id = g_gre_id
1834: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1954: ,per_assignments_f asg

1950: ,pep.effective_end_date
1951: FROM pay_action_information pai
1952: ,pay_assignment_actions paa
1953: ,per_people_f pep
1954: ,per_assignments_f asg
1955: WHERE pai.action_information_category = 'IN_24Q_PERSON'
1956: AND fnd_number.canonical_to_number(pai.action_information1)
1957: BETWEEN p_start_person AND p_end_person
1958: AND pai.action_context_id = paa.assignment_action_id

Line 1971: ,per_assignments_f paf

1967: SELECT
1968: paa.assignment_action_id run_asg_action_id
1969: FROM pay_assignment_actions paa
1970: ,pay_payroll_actions ppa
1971: ,per_assignments_f paf
1972: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
1973: AND paf.assignment_id = paa.assignment_id
1974: AND paa.assignment_id = pai.assignment_id
1975: AND paa.tax_unit_id = pai.action_information3

Line 2121: ,per_assignments_f asg

2117: IS
2118: SELECT pai.action_context_id
2119: FROM pay_action_information pai
2120: ,per_people_f pep
2121: ,per_assignments_f asg
2122: ,pay_assignment_actions paa
2123: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2124: AND fnd_number.canonical_to_number(pai.action_information1)
2125: BETWEEN p_start_person AND p_end_person

Line 2151: ,per_assignments_f paf

2147: SELECT
2148: paa.assignment_action_id run_asg_action_id
2149: FROM pay_assignment_actions paa
2150: ,pay_payroll_actions ppa
2151: ,per_assignments_f paf
2152: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2153: AND paf.assignment_id = paa.assignment_id
2154: AND paa.assignment_id = pai.assignment_id
2155: AND paa.tax_unit_id = pai.action_information3

Line 2265: ,per_assignments_f asg

2261: (
2262: SELECT 1
2263: FROM pay_action_information pai
2264: ,per_people_f pep
2265: ,per_assignments_f asg
2266: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2267: AND fnd_number.canonical_to_number(pai.action_information1)
2268: BETWEEN p_start_person AND p_end_person
2269: AND pai.source_id = p_source_id

Line 2428: ,per_assignments_f paf

2424: ,paf.assignment_id assignment_id
2425: ,NULL last_action_context_id
2426: FROM pay_assignment_actions paa
2427: ,pay_payroll_actions ppa
2428: ,per_assignments_f paf
2429: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2430: AND paf.assignment_id = paa.assignment_id
2431: AND paa.tax_unit_id = g_gre_id
2432: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2461: FROM per_assignments_f

2457:
2458: CURSOR c_bg_check(p_assignment_id NUMBER)
2459: IS
2460: SELECT 1
2461: FROM per_assignments_f
2462: WHERE business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2463: AND assignment_id = p_assignment_id;
2464:
2465: l_procedure VARCHAR2(100);

Line 2751: ,per_assignments_f asg

2747: CURSOR c_pos(p_person_id NUMBER)
2748: IS
2749: SELECT nvl(pos.name,job.name) name
2750: FROM per_positions pos
2751: ,per_assignments_f asg
2752: ,per_jobs job
2753: WHERE asg.position_id=pos.position_id(+)
2754: AND asg.job_id=job.job_id(+)
2755: AND asg.person_id = p_person_id

Line 2766: FROM per_assignments_f asg

2762:
2763: CURSOR c_rep_address(p_person_id NUMBER)
2764: IS
2765: SELECT hou.location_id rep_location
2766: FROM per_assignments_f asg
2767: ,hr_organization_units hou
2768: WHERE asg.person_id = p_person_id
2769: AND asg.primary_flag = 'Y'
2770: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 3886: FROM per_assignments_f asg

3882: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
3883: ,pep.per_information14 pan_ref_number
3884: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
3885: ,pep.effective_end_date
3886: FROM per_assignments_f asg
3887: ,per_people_f pep
3888: WHERE asg.assignment_id = p_assignment_id
3889: AND pep.person_id = asg.person_id
3890: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 3900: ,per_assignments_f paa

3896: CURSOR c_aei_tax_rate(p_person_id NUMBER)
3897: IS
3898: SELECT paei.aei_information2
3899: FROM per_assignment_extra_info paei
3900: ,per_assignments_f paa
3901: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
3902: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
3903: AND paei.assignment_id = paa.assignment_id
3904: AND paa.person_id = p_person_id

Line 4304: FROM per_assignments_f asg

4300: SELECT asg.person_id person_id
4301: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
4302: ,pep.per_information14 pan_ref_number
4303: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
4304: FROM per_assignments_f asg
4305: ,per_people_f pep
4306: WHERE asg.assignment_id = p_assignment_id
4307: AND pep.person_id = asg.person_id
4308: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 4372: FROM per_assignments_f asg

4368: IS
4369: SELECT GREATEST(asg.effective_start_date,g_fin_start_date) start_date
4370: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
4371: ,scl.segment1
4372: FROM per_assignments_f asg
4373: ,hr_soft_coding_keyflex scl
4374: ,pay_assignment_actions paa
4375: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
4376: AND paa.assignment_action_id = p_action_context_id

Line 4395: ,per_assignments_f paf

4391: IS
4392: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
4393: FROM pay_assignment_actions paa
4394: ,pay_payroll_actions ppa
4395: ,per_assignments_f paf
4396: WHERE paf.assignment_id = paa.assignment_id
4397: AND paf.assignment_id = p_assignment_id
4398: AND paa.tax_unit_id = p_tax_unit_id
4399: AND paa.payroll_action_id = ppa.payroll_action_id

Line 5023: ,per_assignments_f paf

5019: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5020: ,paf.assignment_id assignment_id
5021: FROM pay_assignment_actions paa
5022: ,pay_payroll_actions ppa
5023: ,per_assignments_f paf
5024: WHERE paf.assignment_id = paa.assignment_id
5025: AND paf.assignment_id =p_assignment_id
5026: AND paa.tax_unit_id = g_gre_id
5027: AND paa.payroll_action_id = ppa.payroll_action_id

Line 5055: ,per_assignments_f paf

5051: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5052: ,paf.assignment_id assignment_id
5053: FROM pay_assignment_actions paa
5054: ,pay_payroll_actions ppa
5055: ,per_assignments_f paf
5056: WHERE paf.assignment_id = paa.assignment_id
5057: AND paf.assignment_id =p_assignment_id
5058: AND paa.tax_unit_id = g_gre_id
5059: AND paa.payroll_action_id = ppa.payroll_action_id