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_POSITION_LIST

Line 679: INSERT INTO per_position_list

675: IF (l_view_all_organizations_flag = 'N') THEN
676: --
677: hr_utility.set_location('hr_listgen.build_position_list', 10);
678: --
679: INSERT INTO per_position_list
680: (security_profile_id,
681: position_id,
682: request_id,
683: program_application_id,

Line 717: INSERT INTO per_position_list

713: IF ( l_include_top_position_flag = 'Y') THEN
714: --
715: hr_utility.set_location('hr_listgen.build_position_list', 20);
716: --
717: INSERT INTO per_position_list
718: (security_profile_id,
719: position_id,
720: request_id,
721: program_application_id,

Line 745: INSERT INTO per_position_list

741: ELSE -- l_view_all_organizations_flag
742: --
743: hr_utility.set_location('hr_listgen.build_position_list', 30);
744: --
745: INSERT INTO per_position_list
746: (security_profile_id,
747: position_id,
748: request_id,
749: program_application_id,

Line 776: INSERT INTO per_position_list

772: IF ( l_include_top_position_flag = 'Y') THEN
773: --
774: hr_utility.set_location('hr_listgen.build_position_list', 40);
775: --
776: INSERT INTO per_position_list
777: (security_profile_id,
778: position_id,
779: request_id,
780: program_application_id,

Line 1364: fnd_dsql.add_text(', per_position_list pl ');

1360: Fnd_dsql.add_text(', per_person_type_usages_f PERSON_TYPE ');
1361: end if;
1362: --Commented for debug- 8533491
1363: /* if p_sec_rec.view_all_positions_flag='N' then
1364: fnd_dsql.add_text(', per_position_list pl ');
1365: end if;
1366:
1367: if p_sec_rec.view_all_payrolls_flag='N' then
1368: fnd_dsql.add_text( ' , pay_payroll_list ppl ');

Line 1432: fnd_dsql.add_text(' and EXISTS ( SELECT /+ use_nl(per_position_list) / 1 FROM per_position_list ');

1428: /*fnd_dsql.add_text(' and pl.security_profile_id = ');
1429: fnd_dsql.add_bind(p_sec_rec.security_profile_id );
1430: fnd_dsql.add_text(' and (pl.position_id=ASSIGNMENT.position_id or ASSIGNMENT.position_id is null )');*/
1431:
1432: fnd_dsql.add_text(' and EXISTS ( SELECT /*+ use_nl(per_position_list) */ 1 FROM per_position_list ');
1433: fnd_dsql.add_text(' WHERE security_profile_id = ');
1434: fnd_dsql.add_bind(p_sec_rec.security_profile_id );
1435: fnd_dsql.add_text(' and (position_id=ASSIGNMENT.position_id or ASSIGNMENT.position_id is null ))');
1436:

Line 1980: from per_position_list

1976: --
1977: hr_utility.set_location(l_proc, 20);
1978: -- Clearing Position static list
1979: delete
1980: from per_position_list
1981: where security_profile_id = p_security_profile_id
1982: and user_id is null;
1983: --
1984: hr_utility.set_location(l_proc, 30);

Line 3022: per_position_list posl,

3018: if g_debug then
3019: hr_utility.set_location(l_proc, 280);
3020: end if;
3021: l_from_str := ' from per_security_profiles sec,
3022: per_position_list posl,
3023: per_organization_list org ';
3024: -- Modified for bug 11737636
3025: l_cond_str := ' org.security_profile_id = sec.security_profile_id
3026: and posl.security_profile_id = sec.security_profile_id

Line 3289: per_position_list posl ';

3285: if g_debug then
3286: hr_utility.set_location(l_proc, 370);
3287: end if;
3288: l_from_str := ' from per_security_profiles sec,
3289: per_position_list posl ';
3290: --Modified for bug 11737636
3291: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
3292: and posl.position_id = :l_position_id
3293: and sec.view_all_organizations_flag = :l_all

Line 3468: per_position_list posl,

3464: hr_utility.set_location(l_proc, 430);
3465: end if;
3466: l_from_str := ' from per_security_profiles sec,
3467: pay_payroll_list pay,
3468: per_position_list posl,
3469: per_organization_list org ';
3470: l_cond_str := ' org.security_profile_id = sec.security_profile_id
3471: and posl.security_profile_id = sec.security_profile_id
3472: and pay.security_profile_id = sec.security_profile_id

Line 3572: per_position_list posl,

3568: if g_debug then
3569: hr_utility.set_location(l_proc, 460);
3570: end if;
3571: l_from_str := ' from per_security_profiles sec,
3572: per_position_list posl,
3573: per_organization_list org ';
3574: l_cond_str := ' org.security_profile_id = sec.security_profile_id
3575: and posl.security_profile_id = sec.security_profile_id
3576: and posl.security_profile_id = org.security_profile_id

Line 3763: per_position_list posl ';

3759: hr_utility.set_location(l_proc, 520);
3760: end if;
3761: l_from_str := ' from per_security_profiles sec,
3762: pay_payroll_list pay,
3763: per_position_list posl ';
3764: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
3765: and pay.security_profile_id = sec.security_profile_id
3766: and pay.security_profile_id = posl.security_profile_id
3767: and posl.position_id = :l_position_id

Line 3943: per_position_list posl ';

3939: if g_debug then
3940: hr_utility.set_location(l_proc, 580);
3941: end if;
3942: l_from_str := ' from per_security_profiles sec,
3943: per_position_list posl ';
3944: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
3945: and posl.position_id = :l_position_id
3946: and sec.view_all_organizations_flag = :l_all
3947: and sec.view_all_positions_flag = :l_Restrict