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_PEOPLE_F

Line 148: from per_all_people_f papf

144: cursor csr_get_unrelated_contacts is
145: select distinct
146: papf.person_id,
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)

Line 853: per_all_people_f ppl -- per_person_list ppl for bug (6376000/4774264)

849: ,person_id)
850: select distinct p_security_profile_id, l_req_id, l_prog_id,
851: l_appl_id, l_upd_date, pcr.contact_person_id
852: from per_contact_relationships pcr,
853: per_all_people_f ppl -- per_person_list ppl for bug (6376000/4774264)
854: where ppl.person_id = pcr.person_id
855: and (pcr.business_group_id = p_business_group_id or
856: p_business_group_id is null)
857: -- and ppl.security_profile_id = p_security_profile_id for bug (6376000/4774264)

Line 877: per_all_people_f ppl -- per_person_list ppl for bug (6376000/4774264)

873: ,person_id)
874: select distinct p_security_profile_id, l_req_id, l_prog_id,
875: l_appl_id, l_upd_date, pcr.contact_person_id
876: from per_contact_relationships pcr,
877: per_all_people_f ppl -- per_person_list ppl for bug (6376000/4774264)
878: where ppl.person_id = pcr.person_id
879: and (pcr.business_group_id = p_business_group_id or
880: p_business_group_id is null)
881: -- and ppl.security_profile_id = p_security_profile_id for bug (6376000/4774264)

Line 979: from per_all_people_f papf,

975: program_application_id, program_id,
976: program_update_date, person_id)
977: select distinct psp.security_profile_id, l_req_id, l_appl_id,
978: l_prog_id, l_upd_date, papf.person_id
979: from per_all_people_f papf,
980: per_security_profiles psp
981: where psp.security_profile_id = p_security_profile_id
982: and (psp.business_group_id = papf.business_group_id or
983: psp.business_group_id is null)

Line 1012: from per_all_people_f papf,

1008: program_application_id, program_id,
1009: program_update_date, person_id)
1010: select distinct psp.security_profile_id, l_req_id, l_appl_id,
1011: l_prog_id, l_upd_date, papf.person_id
1012: from per_all_people_f papf,
1013: per_security_profiles psp
1014: where psp.security_profile_id = p_security_profile_id
1015: and (psp.business_group_id = papf.business_group_id or
1016: psp.business_group_id is null)

Line 1352: fnd_dsql.add_text(', per_all_people_f PERSON ');

1348: if (instr(UPPER(p_sec_rec.restriction_text),'PERSON.')>0) or
1349: (p_sec_rec.view_all_applicants_flag = 'N'
1350: and (p_sec_rec.view_all_employees_flag <>'Y'
1351: or p_sec_rec.view_all_cwk_flag <>'Y')) then
1352: fnd_dsql.add_text(', per_all_people_f PERSON ');
1353: End if;
1354: --Commented for debug- 8533491
1355: /* if p_sec_rec.view_all_organizations_flag='N' then
1356: Fnd_dsql.add_text(', per_organization_list ol ');

Line 1401: FROM per_all_people_f papf1

1397: fnd_dsql.add_text( ' or (PERSON.effective_start_date>= ');
1398: fnd_dsql.add_bind(to_date(to_char(p_effective_date,'DD/MM/YYYY'),'DD/MM/YYYY'));
1399: fnd_dsql.add_text(' AND NOT EXISTS
1400: (SELECT NULL
1401: FROM per_all_people_f papf1
1402: WHERE papf1.person_id = PERSON.person_id
1403: AND papf1.effective_start_date < PERSON.effective_start_date)) ');
1404:
1405: fnd_dsql.add_text(' ) '); -- 5214715

Line 1889: from per_all_people_f papf

1885: (pspf.view_all_contacts_flag = 'Y' and
1886: pspf.view_all_candidates_flag = 'X')))
1887: /* and ppl.person_id in
1888: (select papf.person_id
1889: from per_all_people_f papf
1890: where papf.person_id = ppl.person_id
1891: and ((p_generation_scope = 'ALL_BUS_GRP' and
1892: papf.business_group_id = p_business_group_id) or
1893: p_generation_scope <> 'ALL_BUS_GRP')) */

Line 1913: from per_all_people_f papf

1909: (pspf.view_all_contacts_flag = 'Y' and
1910: pspf.view_all_candidates_flag = 'X')))
1911: /* and ppl.person_id in
1912: (select papf.person_id
1913: from per_all_people_f papf
1914: where papf.person_id = ppl.person_id
1915: and ((p_generation_scope = 'ALL_BUS_GRP' and
1916: papf.business_group_id = p_business_group_id) or
1917: p_generation_scope <> 'ALL_BUS_GRP')) */

Line 1938: from per_all_people_f papf

1934: (pspf.view_all_contacts_flag = 'Y' and
1935: pspf.view_all_candidates_flag = 'X')))
1936: and ppl.person_id in
1937: (select papf.person_id
1938: from per_all_people_f papf
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

Line 2025: PROCEDURE process_person (p_person_id per_all_people_f.person_id%TYPE,

2021: PARAMETERS
2022: l_effective_date - date for which the secure lists are generated.
2023: ========================================================================= */
2024: --
2025: PROCEDURE process_person (p_person_id per_all_people_f.person_id%TYPE,
2026: p_effective_date date,
2027: p_business_group_id number,
2028: p_generation_scope varchar2,
2029: p_who_to_process varchar2)

Line 2244: per_all_people_f ppf

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
2248: and paf.person_id = ppf.person_id

Line 2257: l_current_employee_flag per_all_people_f.current_employee_flag%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);
2261: l_asgt_str varchar2(2000);

Line 2258: l_current_npw_flag per_all_people_f.current_npw_flag%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);
2261: l_asgt_str varchar2(2000);
2262: l_from_str varchar2(2000);

Line 6108: from per_all_people_f per

6104: or l_generation_scope = 'ALL_GLOBAL'
6105: then
6106: hr_utility.set_location(l_proc,20);
6107: sqlstr := 'select distinct per.person_id
6108: from per_all_people_f per
6109: ,pay_payroll_actions ppa
6110: where ppa.payroll_action_id = :payroll_action_id
6111: order by per.person_id';
6112: -- and ppa.effective_date between per.effective_start_date

Line 6120: from per_all_people_f per

6116: **scope is ALL_BUS_GRP
6117: */
6118: hr_utility.set_location(l_proc,30);
6119: sqlstr := 'select distinct per.person_id
6120: from per_all_people_f per
6121: ,pay_payroll_actions ppa
6122: where ppa.payroll_action_id = :payroll_action_id
6123: and pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'',
6124: ppa.legislative_parameters) =

Line 6152: l_temp_person_id per_all_people_f.person_id%TYPE;

6148: stperson in number,
6149: endperson in number,
6150: chunk in number) is
6151:
6152: l_temp_person_id per_all_people_f.person_id%TYPE;
6153: l_lockingactid pay_assignment_actions.assignment_action_id%TYPE;
6154: l_business_group_id number;
6155: l_generation_scope varchar2(20);
6156: l_who_to_proc varchar2(20);

Line 6324: object_type => 'PER_ALL_PEOPLE_F');

6320: pactid => pactid,
6321: chunk => chunk,
6322: greid => null,
6323: object_id => perrec.person_id,
6324: object_type => 'PER_ALL_PEOPLE_F');
6325: end if;
6326:
6327: if l_temp_person_id <> perrec.person_id then
6328: /*

Line 6339: object_type => 'PER_ALL_PEOPLE_F');

6335: pactid => pactid,
6336: chunk => chunk,
6337: greid => null,
6338: object_id => perrec.person_id,
6339: object_type => 'PER_ALL_PEOPLE_F');
6340: end if;
6341: end loop;
6342:
6343: ELSE

Line 6361: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure

6357: */
6358: l_temp_person_id := asgrec.person_id;
6359:
6360: -- Bug 3630537
6361: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure
6362: -- archive_data needs it to process a person.
6363: hr_nonrun_asact.insact(lockingactid => l_lockingactid,
6364: assignid => -1,
6365: pactid => pactid,

Line 6369: object_type => 'PER_ALL_PEOPLE_F');

6365: pactid => pactid,
6366: chunk => chunk,
6367: greid => null,
6368: object_id => asgrec.person_id,
6369: object_type => 'PER_ALL_PEOPLE_F');
6370: end if;
6371:
6372: if l_temp_person_id <> asgrec.person_id then
6373: /*

Line 6380: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure

6376: */
6377: l_temp_person_id := asgrec.person_id;
6378:
6379: -- Bug 3630537
6380: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure
6381: -- archive_data needs it to process a person.
6382: hr_nonrun_asact.insact(lockingactid => l_lockingactid,
6383: assignid => -1,
6384: pactid => pactid,

Line 6388: object_type => 'PER_ALL_PEOPLE_F');

6384: pactid => pactid,
6385: chunk => chunk,
6386: greid => null,
6387: object_id => asgrec.person_id,
6388: object_type => 'PER_ALL_PEOPLE_F');
6389: end if;
6390: end loop;
6391:
6392: END IF;

Line 6439: l_person_id per_all_people_f.person_id%TYPE;

6435: select ass.object_id
6436: from pay_assignment_actions ass
6437: where ass.assignment_action_id = p_assactid;
6438:
6439: l_person_id per_all_people_f.person_id%TYPE;
6440: l_business_group_id number;
6441: l_generation_scope varchar2(20);
6442: l_who_to_process varchar2(30);
6443: