APPS.PAY_PYUCSLIS_PKG dependencies on PER_POSITION_LIST

Line 615: INSERT INTO per_position_list

611: IF (l_view_all_organizations_flag = 'N') THEN
612: --
613: hr_utility.set_location('hr_listgen.build_position_list', 10);
614: --
615: INSERT INTO per_position_list
616: (security_profile_id,
617: position_id,
618: request_id,
619: program_application_id,

Line 653: INSERT INTO per_position_list

649: IF ( l_include_top_position_flag = 'Y') THEN
650: --
651: hr_utility.set_location('hr_listgen.build_position_list', 20);
652: --
653: INSERT INTO per_position_list
654: (security_profile_id,
655: position_id,
656: request_id,
657: program_application_id,

Line 681: INSERT INTO per_position_list

677: ELSE -- l_view_all_organizations_flag
678: --
679: hr_utility.set_location('hr_listgen.build_position_list', 30);
680: --
681: INSERT INTO per_position_list
682: (security_profile_id,
683: position_id,
684: request_id,
685: program_application_id,

Line 712: INSERT INTO per_position_list

708: IF ( l_include_top_position_flag = 'Y') THEN
709: --
710: hr_utility.set_location('hr_listgen.build_position_list', 40);
711: --
712: INSERT INTO per_position_list
713: (security_profile_id,
714: position_id,
715: request_id,
716: program_application_id,

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

1147: Fnd_dsql.add_text(', per_person_type_usages_f PERSON_TYPE ');
1148: end if;
1149:
1150: if p_sec_rec.view_all_positions_flag='N' then
1151: fnd_dsql.add_text(', per_position_list pl ');
1152: end if;
1153:
1154: if p_sec_rec.view_all_payrolls_flag='N' then
1155: fnd_dsql.add_text( ' , pay_payroll_list ppl ');

Line 1631: from per_position_list

1627: --
1628: hr_utility.set_location(l_proc, 20);
1629: -- Clearing Position static list
1630: delete
1631: from per_position_list
1632: where security_profile_id = p_security_profile_id
1633: and user_id is null;
1634: --
1635: hr_utility.set_location(l_proc, 30);