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.PA_R_PROJECT_RESOURCES_PVT dependencies on PER_ALL_PEOPLE_F

Line 300: from per_all_people_f per /* per_people_f per Commented for bug 2983491 , Added per_all_people_f for it*/

296:
297: cursor validate_person_type
298: is
299: select person_id
300: from per_all_people_f per /* per_people_f per Commented for bug 2983491 , Added per_all_people_f for it*/
301: where per.person_id = p_person_id
302: and (per.current_employee_flag = 'Y' OR per.current_npw_flag = 'Y');
303:
304: cursor get_active_assignment

Line 432: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,

428: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
429: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
430: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
431: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
432: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
433: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
434: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
435: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
436: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,

Line 480: FROM PER_ALL_PEOPLE_F PER, /for bug 2983491 Replaced PER_PEOPLE_F PER , /

476: * The following cursor is for CRM workaround for bug 1944726
477: */
478: CURSOR c_per_active IS
479: SELECT PER.PERSON_ID
480: FROM PER_ALL_PEOPLE_F PER, /*for bug 2983491 Replaced PER_PEOPLE_F PER , */
481: PER_ALL_ASSIGNMENTS_F ASGN
482: WHERE ASGN.PERSON_ID = PER.PERSON_ID
483: AND ASGN.PRIMARY_FLAG = 'Y'
484: AND ASGN.ASSIGNMENT_TYPE in ('E', 'C')

Line 639: FROM per_all_people_f

635: INTO l_fde
636: FROM dual
637: WHERE EXISTS (
638: SELECT 'Y'
639: FROM per_all_people_f
640: WHERE person_id = l_person_id
641: AND (current_employee_flag = 'Y' OR
642: current_npw_flag = 'Y')
643: AND trunc(effective_start_date) > trunc(sysdate));

Line 1435: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,

1431: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
1432: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
1433: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
1434: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
1435: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
1436: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
1437: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
1438: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
1439: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,

Line 2019: l_supervisor_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;

2015: x_exp_ou VARCHAR2(1);
2016: l_res_found VARCHAR2(1) := 'N';
2017: l_valid VARCHAR2(1) := 'N';
2018: l_return_status VARCHAR2(1000);
2019: l_supervisor_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
2020: l_address1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
2021: l_address2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
2022: l_address3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
2023: l_city HR_LOCATIONS.TOWN_OR_CITY%TYPE;

Line 2794: l_from_clause := ' FROM per_all_people_f p ';

2790: -- Organization is not specified.
2791: IF l_p_org_id IS NULL THEN
2792: -- Employee range is specified
2793: l_sel_clause := ' SELECT DISTINCT p.person_id ';
2794: l_from_clause := ' FROM per_all_people_f p ';
2795: -- changed l_where_clause for bug4954896
2796: --l_where_clause := ' WHERE p.employee_number >= ''' || l_from_emp_num || ''''|| ' AND p.employee_number <= ''' || l_to_emp_num || '''';
2797: l_where_clause := ' WHERE p.employee_number >= :from_emp_num AND p.employee_number <= :to_emp_num ';
2798: ELSE

Line 2806: l_from_clause := ' FROM per_all_people_f p, per_all_assignments_f a';

2802: (l_from_emp_num IS NOT NULL AND
2803: l_to_emp_num IS NOT NULL ) THEN
2804:
2805: l_sel_clause := ' SELECT DISTINCT p.person_id ';
2806: l_from_clause := ' FROM per_all_people_f p, per_all_assignments_f a';
2807: -- changed l_where_clause for bug4954896
2808: -- l_where_clause := ' WHERE a.person_id = p.person_id '||
2809: -- ' AND a.organization_id = ' || l_p_org_id ||
2810: -- ' AND p.employee_number >= ''' || l_from_emp_num || ''''||

Line 2854: --l_from_clause := ' FROM per_all_people_f p '; /Commented for Bug 7012687 /

2850: -- Start - Bug 5130414 - PJR Resource Pull Enhancement
2851: IF l_selection_option = 'EMP_RANGE' THEN
2852: -- Employee range is specified
2853: l_sel_clause := ' SELECT DISTINCT p.person_id ';
2854: --l_from_clause := ' FROM per_all_people_f p '; /*Commented for Bug 7012687 */
2855: l_from_clause := ' FROM per_all_people_f p , per_all_assignments_f a'; /*Added per_all_asgn_f for Bug 7012687 */
2856: l_where_clause := ' WHERE p.employee_number >= :from_emp_num AND p.employee_number <= :to_emp_num '||
2857: ' AND p.person_id = a.person_id '|| /*Added condition for Bug 7012687 */
2858: ' AND a.assignment_type in (''E'',''C'') '|| /*Added condition for Bug 7012687 */

Line 2855: l_from_clause := ' FROM per_all_people_f p , per_all_assignments_f a'; /Added per_all_asgn_f for Bug 7012687 /

2851: IF l_selection_option = 'EMP_RANGE' THEN
2852: -- Employee range is specified
2853: l_sel_clause := ' SELECT DISTINCT p.person_id ';
2854: --l_from_clause := ' FROM per_all_people_f p '; /*Commented for Bug 7012687 */
2855: l_from_clause := ' FROM per_all_people_f p , per_all_assignments_f a'; /*Added per_all_asgn_f for Bug 7012687 */
2856: l_where_clause := ' WHERE p.employee_number >= :from_emp_num AND p.employee_number <= :to_emp_num '||
2857: ' AND p.person_id = a.person_id '|| /*Added condition for Bug 7012687 */
2858: ' AND a.assignment_type in (''E'',''C'') '|| /*Added condition for Bug 7012687 */
2859: ' AND a.job_id is not null'|| /*Added condition for Bug 7012687 */

Line 2864: l_from_clause := ' FROM per_all_people_f p, per_all_assignments_f a';

2860: ' AND a.primary_flag = ''Y'' '; /*Added condition for Bug 7012687 */
2861: ELSIF l_selection_option = 'EMP_RANGE_ORG' THEN
2862: -- Employee range and organization is specified
2863: l_sel_clause := ' SELECT DISTINCT p.person_id ';
2864: l_from_clause := ' FROM per_all_people_f p, per_all_assignments_f a';
2865: l_where_clause := ' WHERE a.person_id = p.person_id '||
2866: ' AND a.organization_id = :org_id '||
2867: ' AND p.employee_number >= :from_emp_num '||
2868: ' AND p.employee_number <= :to_emp_num '||

Line 2910: --l_from_clause := ' FROM per_all_people_f p '; /Commented for Bug 7012687 /

2906: -- Selection option not specified (Will never occur, but a check for backward compliance)
2907: IF l_p_org_id IS NULL THEN
2908: -- Employee range is specified
2909: l_sel_clause := ' SELECT DISTINCT p.person_id ';
2910: --l_from_clause := ' FROM per_all_people_f p '; /*Commented for Bug 7012687 */
2911: l_from_clause := ' FROM per_all_people_f p , per_all_assignments_f a '; /*Added per_all_asgn_f for Bug 7012687 */
2912: l_where_clause := ' WHERE p.employee_number >= :from_emp_num AND p.employee_number <= :to_emp_num '||
2913: ' AND p.person_id = a.person_id '|| /*Added condition for Bug 7012687 */
2914: ' AND a.assignment_type in (''E'',''C'') '|| /*Added condition for Bug 7012687 */

Line 2911: l_from_clause := ' FROM per_all_people_f p , per_all_assignments_f a '; /Added per_all_asgn_f for Bug 7012687 /

2907: IF l_p_org_id IS NULL THEN
2908: -- Employee range is specified
2909: l_sel_clause := ' SELECT DISTINCT p.person_id ';
2910: --l_from_clause := ' FROM per_all_people_f p '; /*Commented for Bug 7012687 */
2911: l_from_clause := ' FROM per_all_people_f p , per_all_assignments_f a '; /*Added per_all_asgn_f for Bug 7012687 */
2912: l_where_clause := ' WHERE p.employee_number >= :from_emp_num AND p.employee_number <= :to_emp_num '||
2913: ' AND p.person_id = a.person_id '|| /*Added condition for Bug 7012687 */
2914: ' AND a.assignment_type in (''E'',''C'') '|| /*Added condition for Bug 7012687 */
2915: ' AND a.job_id is not null'|| /*Added condition for Bug 7012687 */

Line 2920: l_from_clause := ' FROM per_all_people_f p, per_all_assignments_f a';

2916: ' AND a.primary_flag = ''Y'' '; /*Added condition for Bug 7012687 */
2917: ELSIF (l_from_emp_num IS NOT NULL AND l_to_emp_num IS NOT NULL) THEN
2918: -- Employee range and Organization is specified
2919: l_sel_clause := ' SELECT DISTINCT p.person_id ';
2920: l_from_clause := ' FROM per_all_people_f p, per_all_assignments_f a';
2921: l_where_clause := ' WHERE a.person_id = p.person_id '||
2922: ' AND a.organization_id = :org_id '||
2923: ' AND p.employee_number >= :from_emp_num '||
2924: ' AND p.employee_number <= :to_emp_num '||