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

1171: ,pep.effective_end_date
1172: FROM pay_action_information pai
1173: ,pay_assignment_actions paa
1174: ,per_people_f pep
1175: ,per_assignments_f asg
1176: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
1177: AND pai.action_context_id = paa.assignment_action_id
1178: AND pai.action_information3 = g_gre_id
1179: AND paa.payroll_action_id = p_payroll_action_id

Line 1188: ,per_assignments_f paa

1184: AND (
1185: (
1186: (NVL(pai.action_information13,'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 1270: ,per_assignments_f asg

1266: IS
1267: SELECT pai.action_context_id
1268: FROM pay_action_information pai
1269: ,per_people_f pep
1270: ,per_assignments_f asg
1271: ,pay_assignment_actions paa
1272: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1273: AND paa.assignment_action_id = pai.action_context_id
1274: AND pai.source_id = p_element_entry_id

Line 1295: ,per_assignments_f paa

1291: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1292: AND (
1293: (NVL(pai.action_information18,'0') <> (SELECT NVL(paei.aei_information2,'0')
1294: FROM per_assignment_extra_info paei
1295: ,per_assignments_f paa
1296: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1297: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1298: AND paei.assignment_id = paa.assignment_id
1299: AND paa.assignment_id = asg.assignment_id

Line 1340: ,per_assignments_f asg

1336: (
1337: SELECT 1
1338: FROM pay_action_information pai
1339: ,per_people_f pep
1340: ,per_assignments_f asg
1341: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1342: AND pai.source_id = p_element_entry_id
1343: AND pai.action_information3 = g_gre_id
1344: AND pai.action_context_id = p_assignment_action_id

Line 1352: ,per_assignments_f paa

1348: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1349: AND (
1350: (NVL(pai.action_information18,'0') = (SELECT NVL(paei.aei_information2,'0')
1351: FROM per_assignment_extra_info paei
1352: ,per_assignments_f paa
1353: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1354: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1355: AND paei.assignment_id = paa.assignment_id
1356: AND paa.assignment_id = asg.assignment_id

Line 1474: FROM per_assignments_f

1470:
1471: CURSOR c_bg_check(p_assignment_id NUMBER)
1472: IS
1473: SELECT 1
1474: FROM per_assignments_f
1475: WHERE business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1476: AND assignment_id = p_assignment_id;
1477:
1478: l_procedure VARCHAR2(100);

Line 1873: ,per_assignments_f paf

1869: SELECT
1870: paa.assignment_action_id run_asg_action_id
1871: FROM pay_assignment_actions paa
1872: ,pay_payroll_actions ppa
1873: ,per_assignments_f paf
1874: WHERE paf.assignment_id = paa.assignment_id
1875: AND paa.assignment_id = pai.assignment_id
1876: AND paa.tax_unit_id = pai.action_information3
1877: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1937: ,per_assignments_f paf

1933: ,paf.assignment_id assignment_id
1934: ,NULL last_action_context_id
1935: FROM pay_assignment_actions paa
1936: ,pay_payroll_actions ppa
1937: ,per_assignments_f paf
1938: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
1939: AND paf.assignment_id = paa.assignment_id
1940: AND paa.tax_unit_id = g_gre_id
1941: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2061: ,per_assignments_f asg

2057: ,pep.effective_end_date
2058: FROM pay_action_information pai
2059: ,pay_assignment_actions paa
2060: ,per_people_f pep
2061: ,per_assignments_f asg
2062: WHERE pai.action_information_category = 'IN_24Q_PERSON'
2063: AND fnd_number.canonical_to_number(pai.action_information1)
2064: BETWEEN p_start_person AND p_end_person
2065: AND pai.action_context_id = paa.assignment_action_id

Line 2078: ,per_assignments_f paf

2074: SELECT
2075: paa.assignment_action_id run_asg_action_id
2076: FROM pay_assignment_actions paa
2077: ,pay_payroll_actions ppa
2078: ,per_assignments_f paf
2079: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2080: AND paf.assignment_id = paa.assignment_id
2081: AND paa.assignment_id = pai.assignment_id
2082: AND paa.tax_unit_id = pai.action_information3

Line 2228: ,per_assignments_f asg

2224: IS
2225: SELECT pai.action_context_id
2226: FROM pay_action_information pai
2227: ,per_people_f pep
2228: ,per_assignments_f asg
2229: ,pay_assignment_actions paa
2230: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2231: AND fnd_number.canonical_to_number(pai.action_information1)
2232: BETWEEN p_start_person AND p_end_person

Line 2258: ,per_assignments_f paf

2254: SELECT
2255: paa.assignment_action_id run_asg_action_id
2256: FROM pay_assignment_actions paa
2257: ,pay_payroll_actions ppa
2258: ,per_assignments_f paf
2259: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2260: AND paf.assignment_id = paa.assignment_id
2261: AND paa.assignment_id = pai.assignment_id
2262: AND paa.tax_unit_id = pai.action_information3

Line 2372: ,per_assignments_f asg

2368: (
2369: SELECT 1
2370: FROM pay_action_information pai
2371: ,per_people_f pep
2372: ,per_assignments_f asg
2373: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2374: AND fnd_number.canonical_to_number(pai.action_information1)
2375: BETWEEN p_start_person AND p_end_person
2376: AND pai.source_id = p_source_id

Line 2535: ,per_assignments_f paf

2531: ,paf.assignment_id assignment_id
2532: ,NULL last_action_context_id
2533: FROM pay_assignment_actions paa
2534: ,pay_payroll_actions ppa
2535: ,per_assignments_f paf
2536: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2537: AND paf.assignment_id = paa.assignment_id
2538: AND paa.tax_unit_id = g_gre_id
2539: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2568: FROM per_assignments_f

2564:
2565: CURSOR c_bg_check(p_assignment_id NUMBER)
2566: IS
2567: SELECT 1
2568: FROM per_assignments_f
2569: WHERE business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2570: AND assignment_id = p_assignment_id;
2571:
2572: l_procedure VARCHAR2(100);

Line 2873: ,per_assignments_f asg

2869: CURSOR c_pos(p_person_id NUMBER)
2870: IS
2871: SELECT nvl(pos.name,job.name) name
2872: FROM per_positions pos
2873: ,per_assignments_f asg
2874: ,per_jobs job
2875: WHERE asg.position_id=pos.position_id(+)
2876: AND asg.job_id=job.job_id(+)
2877: AND asg.person_id = p_person_id

Line 2888: FROM per_assignments_f asg

2884:
2885: CURSOR c_rep_address(p_person_id NUMBER)
2886: IS
2887: SELECT hou.location_id rep_location
2888: FROM per_assignments_f asg
2889: ,hr_organization_units hou
2890: WHERE asg.person_id = p_person_id
2891: AND asg.primary_flag = 'Y'
2892: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 4210: FROM per_assignments_f asg

4206: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
4207: ,pep.per_information14 pan_ref_number
4208: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
4209: ,pep.effective_end_date
4210: FROM per_assignments_f asg
4211: ,per_people_f pep
4212: WHERE asg.assignment_id = p_assignment_id
4213: AND pep.person_id = asg.person_id
4214: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 4224: ,per_assignments_f paa

4220: CURSOR c_aei_tax_rate(p_person_id NUMBER)
4221: IS
4222: SELECT paei.aei_information2
4223: FROM per_assignment_extra_info paei
4224: ,per_assignments_f paa
4225: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
4226: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
4227: AND paei.assignment_id = paa.assignment_id
4228: AND paa.person_id = p_person_id

Line 4628: FROM per_assignments_f asg

4624: SELECT asg.person_id person_id
4625: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
4626: ,pep.per_information14 pan_ref_number
4627: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
4628: FROM per_assignments_f asg
4629: ,per_people_f pep
4630: WHERE asg.assignment_id = p_assignment_id
4631: AND pep.person_id = asg.person_id
4632: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 4696: FROM per_assignments_f asg

4692: IS
4693: SELECT GREATEST(asg.effective_start_date,g_fin_start_date) start_date
4694: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
4695: ,scl.segment1
4696: FROM per_assignments_f asg
4697: ,hr_soft_coding_keyflex scl
4698: ,pay_assignment_actions paa
4699: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
4700: AND paa.assignment_action_id = p_action_context_id

Line 4719: ,per_assignments_f paf

4715: IS
4716: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
4717: FROM pay_assignment_actions paa
4718: ,pay_payroll_actions ppa
4719: ,per_assignments_f paf
4720: WHERE paf.assignment_id = paa.assignment_id
4721: AND paf.assignment_id = p_assignment_id
4722: AND paa.tax_unit_id = p_tax_unit_id
4723: AND paa.payroll_action_id = ppa.payroll_action_id

Line 5347: ,per_assignments_f paf

5343: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5344: ,paf.assignment_id assignment_id
5345: FROM pay_assignment_actions paa
5346: ,pay_payroll_actions ppa
5347: ,per_assignments_f paf
5348: WHERE paf.assignment_id = paa.assignment_id
5349: AND paf.assignment_id =p_assignment_id
5350: AND paa.tax_unit_id = g_gre_id
5351: AND paa.payroll_action_id = ppa.payroll_action_id

Line 5379: ,per_assignments_f paf

5375: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5376: ,paf.assignment_id assignment_id
5377: FROM pay_assignment_actions paa
5378: ,pay_payroll_actions ppa
5379: ,per_assignments_f paf
5380: WHERE paf.assignment_id = paa.assignment_id
5381: AND paf.assignment_id =p_assignment_id
5382: AND paa.tax_unit_id = g_gre_id
5383: AND paa.payroll_action_id = ppa.payroll_action_id