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_PYUCSLIS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 70: from per_all_assignments_f asg

66: p_generation_scope = 'ALL_PROFILES')
67: and pcr.person_id = ppl.person_id
68: and not exists
69: (select /*+ NO_MERGE */ null
70: from per_all_assignments_f asg
71: where asg.person_id = pcr.contact_person_id
72: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
73: and not exists
74: (select /*+ NO_MERGE */ null

Line 107: from per_all_assignments_f asg

103: p_generation_scope = 'ALL_PROFILES')
104: and pcr.person_id = ppl.person_id
105: and not exists
106: (select /*+ NO_MERGE */ null
107: from per_all_assignments_f asg
108: where asg.person_id = pcr.contact_person_id
109: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
110: and not exists
111: (select /*+ NO_MERGE */ null

Line 151: from per_all_assignments_f asg

147: papf.business_group_id
148: from per_all_people_f papf
149: where not exists
150: (select null
151: from per_all_assignments_f asg
152: where asg.person_id = papf.person_id)
153: and not exists
154: (select null
155: from per_contact_relationships pcr

Line 860: from per_all_assignments_f asg

856: p_business_group_id is null)
857: -- and ppl.security_profile_id = p_security_profile_id for bug (6376000/4774264)
858: and not exists
859: (select null
860: from per_all_assignments_f asg
861: where asg.person_id = pcr.contact_person_id
862: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
863: and not exists
864: (select null

Line 884: from per_all_assignments_f asg

880: p_business_group_id is null)
881: -- and ppl.security_profile_id = p_security_profile_id for bug (6376000/4774264)
882: and not exists
883: (select null
884: from per_all_assignments_f asg
885: where asg.person_id = pcr.contact_person_id
886: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
887: and not exists
888: (select null

Line 928: from per_all_assignments_f asg

924: p_business_group_id is null)
925: and ppl.security_profile_id = p_security_profile_id
926: and not exists
927: (select null
928: from per_all_assignments_f asg
929: where asg.person_id = pcr.contact_person_id
930: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
931: and not exists
932: (select null

Line 952: from per_all_assignments_f asg

948: p_business_group_id is null)
949: and ppl.security_profile_id = p_security_profile_id
950: and not exists
951: (select null
952: from per_all_assignments_f asg
953: where asg.person_id = pcr.contact_person_id
954: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
955: and not exists
956: (select null

Line 986: from per_all_assignments_f asg

982: and (psp.business_group_id = papf.business_group_id or
983: psp.business_group_id is null)
984: and not exists
985: (select null
986: from per_all_assignments_f asg
987: where asg.person_id = papf.person_id)
988: and not exists ---- Rever Commneted for for bug 4774264
989: (select null
990: from per_contact_relationships pcr

Line 1019: from per_all_assignments_f asg

1015: and (psp.business_group_id = papf.business_group_id or
1016: psp.business_group_id is null)
1017: and not exists
1018: (select null
1019: from per_all_assignments_f asg
1020: where asg.person_id = papf.person_id)
1021: and not exists ---- Rever Commneted for for bug 4774264
1022: (select null
1023: from per_contact_relationships pcr

Line 1091: FROM per_all_assignments_f pos

1087: FROM per_person_list_changes plc
1088: WHERE plc.security_profile_id = l_security_profile_id
1089: AND NOT EXISTS
1090: (SELECT NULL
1091: FROM per_all_assignments_f pos
1092: WHERE pos.person_id = plc.person_id
1093: AND pos.assignment_type <> 'B'
1094: AND l_effective_date
1095: BETWEEN pos.effective_start_date

Line 1099: FROM per_all_assignments_f pos

1095: BETWEEN pos.effective_start_date
1096: AND pos.effective_end_date)
1097: AND EXISTS
1098: (SELECT NULL
1099: FROM per_all_assignments_f pos
1100: WHERE pos.person_id = plc.person_id
1101: AND l_effective_date > pos.effective_start_date)
1102: AND NOT EXISTS
1103: (SELECT NULL

Line 1127: FROM per_all_assignments_f pos

1123: FROM per_person_list_changes plc
1124: WHERE plc.security_profile_id = l_security_profile_id
1125: AND NOT EXISTS
1126: (SELECT NULL
1127: FROM per_all_assignments_f pos
1128: WHERE pos.person_id = plc.person_id
1129: AND pos.assignment_type <> 'B'
1130: AND l_effective_date
1131: BETWEEN pos.effective_start_date

Line 1135: FROM per_all_assignments_f pos

1131: BETWEEN pos.effective_start_date
1132: AND pos.effective_end_date)
1133: AND EXISTS
1134: (SELECT NULL
1135: FROM per_all_assignments_f pos
1136: WHERE pos.person_id = plc.person_id
1137: AND l_effective_date > pos.effective_start_date)
1138: AND NOT EXISTS
1139: (SELECT NULL

Line 1344: fnd_dsql.add_text(' FROM per_all_assignments_f ASSIGNMENT ');

1340: fnd_dsql.add_text(' , ');
1341: fnd_dsql.add_bind(nvl(p_program_id,''));
1342: fnd_dsql.add_text(' , ');
1343: fnd_dsql.add_bind(to_date(to_char(p_update_date,'DD/MM/YYYY'),'DD/MM/YYYY'));
1344: fnd_dsql.add_text(' FROM per_all_assignments_f ASSIGNMENT ');
1345:
1346: /*-------- additional select clause ---------------*/
1347:
1348: if (instr(UPPER(p_sec_rec.restriction_text),'PERSON.')>0) or

Line 1497: FROM per_all_assignments_f pos1

1493: fnd_dsql.add_text(' between ASSIGNMENT.effective_start_date and ASSIGNMENT.effective_end_date)
1494: or ( ASSIGNMENT.effective_start_date>= ');
1495: fnd_dsql.add_bind(to_date(to_char(p_effective_date,'DD/MM/YYYY'),'DD/MM/YYYY'));
1496: fnd_dsql.add_text(' AND NOT EXISTS ( SELECT NULL
1497: FROM per_all_assignments_f pos1
1498: WHERE pos1.person_id = ASSIGNMENT.person_id AND ');
1499: fnd_dsql.add_bind(to_date(to_char(p_effective_date,'DD/MM/YYYY'),'DD/MM/YYYY'));
1500: fnd_dsql.add_text(' BETWEEN pos1.effective_start_date AND pos1.effective_end_date ) ');
1501: fnd_dsql.add_text('

Line 1504: FROM per_all_assignments_f pos1

1500: fnd_dsql.add_text(' BETWEEN pos1.effective_start_date AND pos1.effective_end_date ) ');
1501: fnd_dsql.add_text('
1502: AND NOT EXISTS
1503: (SELECT NULL
1504: FROM per_all_assignments_f pos1
1505: WHERE pos1.person_id = ASSIGNMENT.person_id
1506: AND ((pos1.assignment_type=''E'' and
1507: pos1.period_of_service_id=ASSIGNMENT.period_of_service_id) or
1508: (pos1.assignment_type=''A'' and

Line 1519: from per_all_assignments_f asg

1515:
1516: fnd_dsql.add_bind(to_date(to_char(p_effective_date,'DD/MM/YYYY'),'DD/MM/YYYY'));
1517: -- added and clause for bug 5168364
1518: fnd_dsql.add_text(' and assignment.effective_end_date = (select max(effective_end_date)
1519: from per_all_assignments_f asg
1520: where asg.person_id = assignment.person_id
1521: and asg.assignment_type in(''A'',''C'',''E'')
1522: ) ');
1523: fnd_dsql.add_text(' AND NOT EXISTS

Line 1525: FROM per_all_assignments_f papf

1521: and asg.assignment_type in(''A'',''C'',''E'')
1522: ) ');
1523: fnd_dsql.add_text(' AND NOT EXISTS
1524: (SELECT NULL
1525: FROM per_all_assignments_f papf
1526: WHERE papf.person_Id = ASSIGNMENT.person_id
1527: AND papf.assignment_type in(''A'',''C'',''E'')
1528: AND papf.effective_end_date >= ');
1529: fnd_dsql.add_bind( to_date(to_char(p_effective_date,'DD/MM/YYYY'),'DD/MM/YYYY'));

Line 1896: from per_all_assignments_f asg

1892: papf.business_group_id = p_business_group_id) or
1893: p_generation_scope <> 'ALL_BUS_GRP')) */
1894: and not exists
1895: (select null
1896: from per_all_assignments_f asg
1897: where asg.person_id = ppl.person_id)
1898: and not exists
1899: (select null
1900: from per_contact_relationships pcr

Line 1920: from per_all_assignments_f asg

1916: papf.business_group_id = p_business_group_id) or
1917: p_generation_scope <> 'ALL_BUS_GRP')) */
1918: and not exists
1919: (select null
1920: from per_all_assignments_f asg
1921: where asg.person_id = ppl.person_id)
1922: and not exists
1923: (select null
1924: from per_contact_relationships pcr

Line 1943: from per_all_assignments_f asg

1939: where papf.person_id = ppl.person_id
1940: and papf.business_group_id = p_business_group_id)
1941: and not exists
1942: (select null
1943: from per_all_assignments_f asg
1944: where asg.person_id = ppl.person_id)
1945: and not exists
1946: (select null
1947: from per_contact_relationships pcr

Line 2123: per_all_assignments_f paf

2119: select ppf.person_id, paf.assignment_type,
2120: least(max(paf.effective_end_date), p_effective_date) effective_date
2121: from per_person_type_usages_f ppf,
2122: per_person_types ppt,
2123: per_all_assignments_f paf
2124: where ppf.person_id = p_person_id
2125: and ppf.person_id = paf.person_id
2126: and paf.assignment_type in ('A','C','E')
2127: and paf.effective_start_date < p_effective_date

Line 2174: from per_all_assignments_f paf

2170:
2171: cursor c_get_asg(p_person_id number,
2172: p_effective_date date) is
2173: select paf.assignment_id, paf.effective_start_date
2174: from per_all_assignments_f paf
2175: where paf.person_id = p_person_id
2176: and paf.assignment_type not in ('B','O') -- added from bug 4352765, Bug 7412855
2177: and ( (p_effective_date between paf.effective_start_date
2178: and paf.effective_end_date)

Line 2182: from per_all_assignments_f paf1

2178: and paf.effective_end_date)
2179: or
2180: (paf.effective_start_date > p_effective_date and
2181: not exists (select null
2182: from per_all_assignments_f paf1
2183: where paf1.assignment_id = paf.assignment_id
2184: and paf1.effective_start_date <=
2185: paf.effective_start_date)));
2186:

Line 2209: l_assignment_type PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE;

2205: l_is_current_apl varchar2(1) := 'N';
2206: l_is_former varchar2(1) := 'N';
2207:
2208: l_person_id number;
2209: l_assignment_type PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE;
2210: l_person_proc_date date;
2211: lc_person_id number(10); -- Bug6809753
2212: l_cleared_ppl boolean := FALSE;
2213:

Line 2243: from per_all_assignments_f paf,

2239: paf.business_group_id,
2240: paf.assignment_type,
2241: ppf.current_employee_flag,
2242: ppf.current_npw_flag
2243: from per_all_assignments_f paf,
2244: per_all_people_f ppf
2245: where paf.assignment_id = p_assignment_id
2246: and p_effective_date between paf.effective_start_date
2247: and paf.effective_end_date

Line 2251: l_person_id per_all_assignments_f.person_id%type;

2247: and paf.effective_end_date
2248: and paf.person_id = ppf.person_id
2249: and p_effective_date between ppf.effective_start_date
2250: and ppf.effective_end_date;
2251: l_person_id per_all_assignments_f.person_id%type;
2252: l_organization_id per_all_assignments_f.organization_id%type;
2253: l_position_id per_all_assignments_f.position_id%type;
2254: l_payroll_id per_all_assignments_f.payroll_id%type;
2255: l_business_group_id per_all_assignments_f.business_group_id%type;

Line 2252: l_organization_id per_all_assignments_f.organization_id%type;

2248: and paf.person_id = ppf.person_id
2249: and p_effective_date between ppf.effective_start_date
2250: and ppf.effective_end_date;
2251: l_person_id per_all_assignments_f.person_id%type;
2252: l_organization_id per_all_assignments_f.organization_id%type;
2253: l_position_id per_all_assignments_f.position_id%type;
2254: l_payroll_id per_all_assignments_f.payroll_id%type;
2255: l_business_group_id per_all_assignments_f.business_group_id%type;
2256: l_assignment_type per_all_assignments_f.assignment_type%type;

Line 2253: l_position_id per_all_assignments_f.position_id%type;

2249: and p_effective_date between ppf.effective_start_date
2250: and ppf.effective_end_date;
2251: l_person_id per_all_assignments_f.person_id%type;
2252: l_organization_id per_all_assignments_f.organization_id%type;
2253: l_position_id per_all_assignments_f.position_id%type;
2254: l_payroll_id per_all_assignments_f.payroll_id%type;
2255: l_business_group_id per_all_assignments_f.business_group_id%type;
2256: l_assignment_type per_all_assignments_f.assignment_type%type;
2257: l_current_employee_flag per_all_people_f.current_employee_flag%type;

Line 2254: l_payroll_id per_all_assignments_f.payroll_id%type;

2250: and ppf.effective_end_date;
2251: l_person_id per_all_assignments_f.person_id%type;
2252: l_organization_id per_all_assignments_f.organization_id%type;
2253: l_position_id per_all_assignments_f.position_id%type;
2254: l_payroll_id per_all_assignments_f.payroll_id%type;
2255: l_business_group_id per_all_assignments_f.business_group_id%type;
2256: l_assignment_type per_all_assignments_f.assignment_type%type;
2257: l_current_employee_flag per_all_people_f.current_employee_flag%type;
2258: l_current_npw_flag per_all_people_f.current_npw_flag%type;

Line 2255: l_business_group_id per_all_assignments_f.business_group_id%type;

2251: l_person_id per_all_assignments_f.person_id%type;
2252: l_organization_id per_all_assignments_f.organization_id%type;
2253: l_position_id per_all_assignments_f.position_id%type;
2254: l_payroll_id per_all_assignments_f.payroll_id%type;
2255: l_business_group_id per_all_assignments_f.business_group_id%type;
2256: l_assignment_type per_all_assignments_f.assignment_type%type;
2257: l_current_employee_flag per_all_people_f.current_employee_flag%type;
2258: l_current_npw_flag per_all_people_f.current_npw_flag%type;
2259:

Line 2256: l_assignment_type per_all_assignments_f.assignment_type%type;

2252: l_organization_id per_all_assignments_f.organization_id%type;
2253: l_position_id per_all_assignments_f.position_id%type;
2254: l_payroll_id per_all_assignments_f.payroll_id%type;
2255: l_business_group_id per_all_assignments_f.business_group_id%type;
2256: l_assignment_type per_all_assignments_f.assignment_type%type;
2257: l_current_employee_flag per_all_people_f.current_employee_flag%type;
2258: l_current_npw_flag per_all_people_f.current_npw_flag%type;
2259:
2260: l_bggr_str varchar2(1000);

Line 6255: from per_all_assignments_f asg

6251: stperson number,
6252: endperson number) is
6253: select distinct asg.assignment_id,
6254: asg.person_id
6255: from per_all_assignments_f asg
6256: ,pay_payroll_actions ppa
6257: where asg.assignment_type in ('E','A','C')
6258: and asg.person_id between stperson and endperson
6259: and ppa.payroll_action_id = pactid

Line 6279: from per_all_assignments_f paf1

6275: and asg.effective_end_date)
6276: or
6277: (asg.effective_start_date > ppa.effective_date and
6278: not exists (select null
6279: from per_all_assignments_f paf1
6280: where paf1.assignment_id = asg.assignment_id
6281: and paf1.effective_start_date <
6282: ppa.effective_date)));
6283: