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_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_ROLE_TYPES

Line 86: pa_project_role_types_b r1,

82:
83: CURSOR c_duplicate_customer_org IS
84: SELECT 'Y'
85: FROM pa_project_parties ppp,
86: pa_project_role_types_b r1,
87: pa_project_role_types_b r2
88: WHERE r1.project_role_id = p_project_role_id
89: AND r1.role_party_class = 'CUSTOMER'
90: AND ppp.object_id = p_object_id

Line 87: pa_project_role_types_b r2

83: CURSOR c_duplicate_customer_org IS
84: SELECT 'Y'
85: FROM pa_project_parties ppp,
86: pa_project_role_types_b r1,
87: pa_project_role_types_b r2
88: WHERE r1.project_role_id = p_project_role_id
89: AND r1.role_party_class = 'CUSTOMER'
90: AND ppp.object_id = p_object_id
91: AND ppp.object_type = p_object_type

Line 182: FROM pa_project_role_types_b

178: l_dummy := 'N';
179: BEGIN
180: SELECT 'Y'
181: INTO l_dummy
182: FROM pa_project_role_types_b
183: WHERE project_role_id = p_project_role_id
184: AND p_start_date_active BETWEEN start_date_active AND NVL(end_date_active,p_start_date_active)
185: AND (p_end_date_active IS NULL
186: OR p_end_date_active BETWEEN start_date_active AND NVL(end_date_active,p_end_date_active));

Line 599: FROM pa_project_role_types_vl

595: BEGIN
596: IF p_project_role_type IS NOT NULL THEN
597: BEGIN
598: SELECT project_role_id INTO l_project_role_id
599: FROM pa_project_role_types_vl
600: WHERE (meaning = p_project_role_type AND p_calling_module <> 'FORM')
601: OR (project_role_type = p_project_role_type AND p_calling_module = 'FORM');
602: RETURN l_project_role_id;
603: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 709: pa_project_role_types pprt,

705: x_project_role_id,
706: x_project_role_name,
707: x_manager_name
708: FROM pa_project_parties ppp,
709: pa_project_role_types pprt,
710: per_all_people_f pe
711: WHERE ppp.project_id = p_project_id
712: AND ppp.project_role_id = 1
713: AND ppp.project_role_id = pprt.project_role_id

Line 733: pa_project_role_types pprt,

729: x_project_role_id,
730: x_project_role_name,
731: x_manager_name
732: FROM pa_project_parties ppp,
733: pa_project_role_types pprt,
734: per_all_people_f pe
735: WHERE ppp.project_id = p_project_id
736: AND ppp.project_role_id = 1
737: AND ppp.project_role_id = pprt.project_role_id

Line 774: pa_project_role_types_b r,

770: BEGIN
771: SELECT project_party_id
772: INTO ret
773: FROM pa_project_parties p,
774: pa_project_role_types_b r,
775: pa_customers_v c
776: WHERE r.role_party_class = 'CUSTOMER'
777: AND p.project_role_id = r.project_role_id
778: AND p.project_id = p_project_id

Line 796: l_role_party_class pa_project_role_types_b.role_party_class%TYPE;

792: p_resource_source_id IN NUMBER,
793: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
794:
795: l_party_type VARCHAR2(30) := 'PERSON';
796: l_role_party_class pa_project_role_types_b.role_party_class%TYPE;
797: BEGIN
798: pa_debug.set_err_stack('Validate_role_party');
799:
800: -- Check if the resource is a Person/Organization.

Line 811: FROM pa_project_role_types_b

807:
808: -- Check if the role is for Person/Organization.
809: SELECT role_party_class
810: INTO l_role_party_class
811: FROM pa_project_role_types_b
812: WHERE project_role_id = p_project_role_id;
813:
814: x_error_occured := 'N';
815:

Line 840: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821

836:
837: CURSOR C1 (c_as_of_date DATE) IS
838: Select PPP.RESOURCE_SOURCE_ID
839: FROM PA_PROJECT_PARTIES PPP ,
840: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
841: PA_PROJECT_ROLE_TYPES_B PPRT
842: WHERE
843: PPP.PROJECT_ID = p_project_id
844: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID

Line 841: PA_PROJECT_ROLE_TYPES_B PPRT

837: CURSOR C1 (c_as_of_date DATE) IS
838: Select PPP.RESOURCE_SOURCE_ID
839: FROM PA_PROJECT_PARTIES PPP ,
840: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
841: PA_PROJECT_ROLE_TYPES_B PPRT
842: WHERE
843: PPP.PROJECT_ID = p_project_id
844: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
845: AND ppp.resource_type_id = 101 --Added this condition to improve performance. Bug:4752054

Line 919: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821

915:
916: CURSOR C1 (c_as_of_date DATE) IS
917: Select ppf.full_name
918: FROM PA_PROJECT_PARTIES PPP,
919: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
920: PA_PROJECT_ROLE_TYPES_B PPRT,
921: per_all_people_f PPF
922: WHERE
923: PPP.PROJECT_ID = p_project_id

Line 920: PA_PROJECT_ROLE_TYPES_B PPRT,

916: CURSOR C1 (c_as_of_date DATE) IS
917: Select ppf.full_name
918: FROM PA_PROJECT_PARTIES PPP,
919: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
920: PA_PROJECT_ROLE_TYPES_B PPRT,
921: per_all_people_f PPF
922: WHERE
923: PPP.PROJECT_ID = p_project_id
924: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID

Line 1297: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821

1293:
1294: CURSOR C1 (c_as_of_date DATE) IS
1295: Select PPP.RESOURCE_SOURCE_ID
1296: FROM PA_PROJECT_PARTIES PPP ,
1297: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
1298: PA_PROJECT_ROLE_TYPES_B PPRT
1299: WHERE
1300: PPP.PROJECT_ID = p_project_id
1301: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID

Line 1298: PA_PROJECT_ROLE_TYPES_B PPRT

1294: CURSOR C1 (c_as_of_date DATE) IS
1295: Select PPP.RESOURCE_SOURCE_ID
1296: FROM PA_PROJECT_PARTIES PPP ,
1297: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
1298: PA_PROJECT_ROLE_TYPES_B PPRT
1299: WHERE
1300: PPP.PROJECT_ID = p_project_id
1301: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1302: AND ppp.resource_type_id = 101 --Added this condition to improve performance. Bug:4752054

Line 1342: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821

1338:
1339: CURSOR C1 (c_as_of_date DATE) IS
1340: Select ppf.full_name
1341: FROM PA_PROJECT_PARTIES PPP,
1342: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
1343: PA_PROJECT_ROLE_TYPES_B PPRT,
1344: per_all_people_f PPF
1345: WHERE
1346: PPP.PROJECT_ID = p_project_id

Line 1343: PA_PROJECT_ROLE_TYPES_B PPRT,

1339: CURSOR C1 (c_as_of_date DATE) IS
1340: Select ppf.full_name
1341: FROM PA_PROJECT_PARTIES PPP,
1342: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
1343: PA_PROJECT_ROLE_TYPES_B PPRT,
1344: per_all_people_f PPF
1345: WHERE
1346: PPP.PROJECT_ID = p_project_id
1347: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID