DBA Data[Home] [Help]

APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on HR_LOCATIONS

Line 29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,

25: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
26: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
32: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
33: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,

Line 30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,

26: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
32: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
33: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
34: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,

Line 31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,

27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
32: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
33: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
34: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
35: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,

Line 32: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,

28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
32: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
33: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
34: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
35: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
36: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,

Line 33: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,

29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
32: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
33: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
34: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
35: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
36: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
37: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,

Line 34: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,

30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
32: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
33: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
34: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
35: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
36: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
37: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
38: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,

Line 85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,

81: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
82: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
88: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
89: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,

Line 86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,

82: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
88: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
89: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
90: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,

Line 87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,

83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
88: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
89: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
90: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
91: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,

Line 88: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,

84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
88: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
89: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
90: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
91: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
92: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,

Line 89: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,

85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
88: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
89: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
90: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
91: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
92: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
93: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,

Line 90: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,

86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
88: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
89: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
90: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
91: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
92: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
93: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
94: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,