APPS.PA_PROJECT_PUB dependencies on HZ_PARTIES

Line 9767: hz_parties hzo,

9763: ppp.resource_source_id RESOURCE_PARTY_ID
9764: FROM pa_project_parties ppp,
9765: pa_projects_all ppa,
9766: pa_project_role_types_vl pprt,
9767: hz_parties hzo,
9768: hz_contact_points hzcp
9769: WHERE ppp.resource_type_id = 112
9770: AND ppp.project_id = ppa.project_id
9771: AND ppp.project_role_id = pprt.project_role_id

Line 9774: AND hzcp.owner_table_name (+)= 'HZ_PARTIES'

9770: AND ppp.project_id = ppa.project_id
9771: AND ppp.project_role_id = pprt.project_role_id
9772: AND ppp.resource_source_id = hzo.party_id
9773: AND hzo.party_type = 'ORGANIZATION'
9774: AND hzcp.owner_table_name (+)= 'HZ_PARTIES'
9775: AND hzcp.owner_table_id (+)= hzo.party_id
9776: AND hzcp.contact_point_type (+)= 'PHONE'
9777: AND hzcp.phone_line_type (+)= 'GEN'
9778: AND hzcp.primary_flag (+)= 'Y'

Line 9785: -- using hz_parties columns for primary phone number details

9781: AND PPRT.project_role_type = l_role_type;
9782: */
9783:
9784: -- Added same cursor with changed select query , removed hz_contact_points references
9785: -- using hz_parties columns for primary phone number details
9786: -- ( like primary_phone_area_code , primary_phone_number , primary_phone_extension )
9787: -- for more refer bug description
9788:
9789: CURSOR l_org_role_csr (l_project_id NUMBER,l_resource_source_id NUMBER,

Line 9829: hz_parties hzo

9825: ppp.resource_source_id RESOURCE_PARTY_ID
9826: FROM pa_project_parties ppp,
9827: pa_projects_all ppa,
9828: pa_project_role_types_vl pprt,
9829: hz_parties hzo
9830: WHERE ppp.resource_type_id = 112
9831: AND ppp.project_id = ppa.project_id
9832: AND ppp.project_role_id = pprt.project_role_id
9833: AND ppp.resource_source_id = hzo.party_id

Line 10363: FROM hz_parties party,

10359:
10360: CURSOR cur_customer_status(l_customer_id number)
10361: IS
10362: SELECT Nvl(cust_acct.status,'A')
10363: FROM hz_parties party,
10364: hz_cust_accounts cust_acct
10365: WHERE
10366: cust_acct.party_id = party.party_id AND
10367: cust_acct.cust_account_id = l_customer_id;

Line 19378: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539

19374: IF 'Y' = p_project_in.enable_top_task_customer_flag AND 'N' = l_old_cust_top_task_flag THEN -- 4188765 added
19375: --Enabling the customer at top task flag. Thus, we need to set the default top task customer
19376: DECLARE
19377: hghst_ctr_cust_id NUMBER;
19378: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19379: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19380:
19381: l_return_status VARCHAR2(10);
19382: l_msg_count NUMBER := 0;

Line 19379: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539

19375: --Enabling the customer at top task flag. Thus, we need to set the default top task customer
19376: DECLARE
19377: hghst_ctr_cust_id NUMBER;
19378: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19379: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19380:
19381: l_return_status VARCHAR2(10);
19382: l_msg_count NUMBER := 0;
19383: l_msg_data VARCHAR2(2000);

Line 19479: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539

19475: --Disabling the customer at top task flag. Thus, we need to set the customer bill split for the project customers
19476: DECLARE
19477: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;
19478: hghst_ctr_cust_id NUMBER;
19479: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19480: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19481: -- num_customers NUMBER := 0; bug 5622539
19482: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
19483:

Line 19480: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539

19476: DECLARE
19477: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;
19478: hghst_ctr_cust_id NUMBER;
19479: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19480: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19481: -- num_customers NUMBER := 0; bug 5622539
19482: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
19483:
19484: l_return_status VARCHAR2(10);