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 60: from per_all_assignments_f asg

56: p_generation_scope = 'ALL_PROFILES')
57: and pcr.person_id = ppl.person_id
58: and not exists
59: (select /*+ NO_MERGE */ null
60: from per_all_assignments_f asg
61: where asg.person_id = pcr.contact_person_id
62: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
63: and not exists
64: (select /*+ NO_MERGE */ null

Line 103: from per_all_assignments_f asg

99: papf.business_group_id
100: from per_all_people_f papf
101: where not exists
102: (select null
103: from per_all_assignments_f asg
104: where asg.person_id = papf.person_id)
105: and not exists
106: (select null
107: from per_contact_relationships pcr

Line 793: from per_all_assignments_f asg

789: p_business_group_id is null)
790: -- and ppl.security_profile_id = p_security_profile_id for bug (6376000/4774264)
791: and not exists
792: (select null
793: from per_all_assignments_f asg
794: where asg.person_id = pcr.contact_person_id
795: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
796: and not exists
797: (select null

Line 832: from per_all_assignments_f asg

828: p_business_group_id is null)
829: and ppl.security_profile_id = p_security_profile_id
830: and not exists
831: (select null
832: from per_all_assignments_f asg
833: where asg.person_id = pcr.contact_person_id
834: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
835: and not exists
836: (select null

Line 862: from per_all_assignments_f asg

858: and (psp.business_group_id = papf.business_group_id or
859: psp.business_group_id is null)
860: and not exists
861: (select null
862: from per_all_assignments_f asg
863: where asg.person_id = papf.person_id)
864: and not exists ---- Rever Commneted for for bug 4774264
865: (select null
866: from per_contact_relationships pcr

Line 929: FROM per_all_assignments_f pos

925: FROM per_person_list_changes plc
926: WHERE plc.security_profile_id = l_security_profile_id
927: AND NOT EXISTS
928: (SELECT NULL
929: FROM per_all_assignments_f pos
930: WHERE pos.person_id = plc.person_id
931: AND pos.assignment_type <> 'B'
932: AND l_effective_date
933: BETWEEN pos.effective_start_date

Line 937: FROM per_all_assignments_f pos

933: BETWEEN pos.effective_start_date
934: AND pos.effective_end_date)
935: AND EXISTS
936: (SELECT NULL
937: FROM per_all_assignments_f pos
938: WHERE pos.person_id = plc.person_id
939: AND l_effective_date > pos.effective_start_date)
940: AND NOT EXISTS
941: (SELECT NULL

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

1127: fnd_dsql.add_text(' , ');
1128: fnd_dsql.add_bind(nvl(p_program_id,''));
1129: fnd_dsql.add_text(' , ');
1130: fnd_dsql.add_bind(to_date(to_char(p_update_date,'DD/MM/YYYY'),'DD/MM/YYYY'));
1131: fnd_dsql.add_text(' FROM per_all_assignments_f ASSIGNMENT ');
1132:
1133: /*-------- additional select clause ---------------*/
1134:
1135: if (instr(UPPER(p_sec_rec.restriction_text),'PERSON.')>0) or

Line 1264: FROM per_all_assignments_f pos1

1260: fnd_dsql.add_text(' between ASSIGNMENT.effective_start_date and ASSIGNMENT.effective_end_date)
1261: or ( ASSIGNMENT.effective_start_date>= ');
1262: fnd_dsql.add_bind(to_date(to_char(p_effective_date,'DD/MM/YYYY'),'DD/MM/YYYY'));
1263: fnd_dsql.add_text(' AND NOT EXISTS ( SELECT NULL
1264: FROM per_all_assignments_f pos1
1265: WHERE pos1.person_id = ASSIGNMENT.person_id AND ');
1266: fnd_dsql.add_bind(to_date(to_char(p_effective_date,'DD/MM/YYYY'),'DD/MM/YYYY'));
1267: fnd_dsql.add_text(' BETWEEN pos1.effective_start_date AND pos1.effective_end_date ) ');
1268: fnd_dsql.add_text('

Line 1271: FROM per_all_assignments_f pos1

1267: fnd_dsql.add_text(' BETWEEN pos1.effective_start_date AND pos1.effective_end_date ) ');
1268: fnd_dsql.add_text('
1269: AND NOT EXISTS
1270: (SELECT NULL
1271: FROM per_all_assignments_f pos1
1272: WHERE pos1.person_id = ASSIGNMENT.person_id
1273: AND ((pos1.assignment_type=''E'' and
1274: pos1.period_of_service_id=ASSIGNMENT.period_of_service_id) or
1275: (pos1.assignment_type=''A'' and

Line 1286: from per_all_assignments_f asg

1282:
1283: fnd_dsql.add_bind(to_date(to_char(p_effective_date,'DD/MM/YYYY'),'DD/MM/YYYY'));
1284: -- added and clause for bug 5168364
1285: fnd_dsql.add_text(' and assignment.effective_end_date = (select max(effective_end_date)
1286: from per_all_assignments_f asg
1287: where asg.person_id = assignment.person_id
1288: and asg.assignment_type in(''A'',''C'',''E'')
1289: ) ');
1290: fnd_dsql.add_text(' AND NOT EXISTS

Line 1292: FROM per_all_assignments_f papf

1288: and asg.assignment_type in(''A'',''C'',''E'')
1289: ) ');
1290: fnd_dsql.add_text(' AND NOT EXISTS
1291: (SELECT NULL
1292: FROM per_all_assignments_f papf
1293: WHERE papf.person_Id = ASSIGNMENT.person_id
1294: AND papf.assignment_type in(''A'',''C'',''E'')
1295: AND papf.effective_end_date >= ');
1296: fnd_dsql.add_bind( to_date(to_char(p_effective_date,'DD/MM/YYYY'),'DD/MM/YYYY'));

Line 1572: from per_all_assignments_f asg

1568: papf.business_group_id = p_business_group_id) or
1569: p_generation_scope <> 'ALL_BUS_GRP')) */
1570: and not exists
1571: (select null
1572: from per_all_assignments_f asg
1573: where asg.person_id = ppl.person_id)
1574: and not exists
1575: (select null
1576: from per_contact_relationships pcr

Line 1594: from per_all_assignments_f asg

1590: where papf.person_id = ppl.person_id
1591: and papf.business_group_id = p_business_group_id)
1592: and not exists
1593: (select null
1594: from per_all_assignments_f asg
1595: where asg.person_id = ppl.person_id)
1596: and not exists
1597: (select null
1598: from per_contact_relationships pcr

Line 1763: per_all_assignments_f paf

1759: select ppf.person_id, paf.assignment_type,
1760: least(max(paf.effective_end_date), p_effective_date) effective_date
1761: from per_person_type_usages_f ppf,
1762: per_person_types ppt,
1763: per_all_assignments_f paf
1764: where ppf.person_id = p_person_id
1765: and ppf.person_id = paf.person_id
1766: and paf.assignment_type in ('A','C','E')
1767: and paf.effective_start_date < p_effective_date

Line 1814: from per_all_assignments_f paf

1810:
1811: cursor c_get_asg(p_person_id number,
1812: p_effective_date date) is
1813: select paf.assignment_id, paf.effective_start_date
1814: from per_all_assignments_f paf
1815: where paf.person_id = p_person_id
1816: and paf.assignment_type not in ('B','O') -- added from bug 4352765, Bug 7412855
1817: and ( (p_effective_date between paf.effective_start_date
1818: and paf.effective_end_date)

Line 1822: from per_all_assignments_f paf1

1818: and paf.effective_end_date)
1819: or
1820: (paf.effective_start_date > p_effective_date and
1821: not exists (select null
1822: from per_all_assignments_f paf1
1823: where paf1.assignment_id = paf.assignment_id
1824: and paf1.effective_start_date <=
1825: paf.effective_start_date)));
1826:

Line 1849: l_assignment_type PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE;

1845: l_is_current_apl varchar2(1) := 'N';
1846: l_is_former varchar2(1) := 'N';
1847:
1848: l_person_id number;
1849: l_assignment_type PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_TYPE%TYPE;
1850: l_person_proc_date date;
1851: lc_person_id number(10); -- Bug6809753
1852: l_cleared_ppl boolean := FALSE;
1853:

Line 3258: from per_all_assignments_f asg

3254: stperson number,
3255: endperson number) is
3256: select distinct asg.assignment_id,
3257: asg.person_id
3258: from per_all_assignments_f asg
3259: ,pay_payroll_actions ppa
3260: where asg.assignment_type in ('E','A','C')
3261: and asg.person_id between stperson and endperson
3262: and ppa.payroll_action_id = pactid

Line 3282: from per_all_assignments_f paf1

3278: and asg.effective_end_date)
3279: or
3280: (asg.effective_start_date > ppa.effective_date and
3281: not exists (select null
3282: from per_all_assignments_f paf1
3283: where paf1.assignment_id = asg.assignment_id
3284: and paf1.effective_start_date <
3285: ppa.effective_date)));
3286: