APPS.PA_PROJECT_PUB dependencies on HZ_PARTIES

Line 10019: hz_parties hzo,

10015: ppp.resource_source_id RESOURCE_PARTY_ID
10016: FROM pa_project_parties ppp,
10017: pa_projects_all ppa,
10018: pa_project_role_types_vl pprt,
10019: hz_parties hzo,
10020: hz_contact_points hzcp
10021: WHERE ppp.resource_type_id = 112
10022: AND ppp.project_id = ppa.project_id
10023: AND ppp.project_role_id = pprt.project_role_id

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

10022: AND ppp.project_id = ppa.project_id
10023: AND ppp.project_role_id = pprt.project_role_id
10024: AND ppp.resource_source_id = hzo.party_id
10025: AND hzo.party_type = 'ORGANIZATION'
10026: AND hzcp.owner_table_name (+)= 'HZ_PARTIES'
10027: AND hzcp.owner_table_id (+)= hzo.party_id
10028: AND hzcp.contact_point_type (+)= 'PHONE'
10029: AND hzcp.phone_line_type (+)= 'GEN'
10030: AND hzcp.primary_flag (+)= 'Y'

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

10033: AND PPRT.project_role_type = l_role_type;
10034: */
10035:
10036: -- Added same cursor with changed select query , removed hz_contact_points references
10037: -- using hz_parties columns for primary phone number details
10038: -- ( like primary_phone_area_code , primary_phone_number , primary_phone_extension )
10039: -- for more refer bug description
10040:
10041: CURSOR l_org_role_csr (l_project_id NUMBER,l_resource_source_id NUMBER,

Line 10081: hz_parties hzo

10077: ppp.resource_source_id RESOURCE_PARTY_ID
10078: FROM pa_project_parties ppp,
10079: pa_projects_all ppa,
10080: pa_project_role_types_vl pprt,
10081: hz_parties hzo
10082: WHERE ppp.resource_type_id = 112
10083: AND ppp.project_id = ppa.project_id
10084: AND ppp.project_role_id = pprt.project_role_id
10085: AND ppp.resource_source_id = hzo.party_id

Line 10625: FROM hz_parties party,

10621:
10622: CURSOR cur_customer_status(l_customer_id number)
10623: IS
10624: SELECT Nvl(cust_acct.status,'A')
10625: FROM hz_parties party,
10626: hz_cust_accounts cust_acct
10627: WHERE
10628: cust_acct.party_id = party.party_id AND
10629: cust_acct.cust_account_id = l_customer_id;

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

19772: IF 'Y' = p_project_in.enable_top_task_customer_flag AND 'N' = l_old_cust_top_task_flag THEN -- 4188765 added
19773: --Enabling the customer at top task flag. Thus, we need to set the default top task customer
19774: DECLARE
19775: hghst_ctr_cust_id NUMBER;
19776: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19777: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19778:
19779: l_return_status VARCHAR2(10);
19780: l_msg_count NUMBER := 0;

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

19773: --Enabling the customer at top task flag. Thus, we need to set the default top task customer
19774: DECLARE
19775: hghst_ctr_cust_id NUMBER;
19776: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19777: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19778:
19779: l_return_status VARCHAR2(10);
19780: l_msg_count NUMBER := 0;
19781: l_msg_data VARCHAR2(2000);

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

19873: --Disabling the customer at top task flag. Thus, we need to set the customer bill split for the project customers
19874: DECLARE
19875: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;
19876: hghst_ctr_cust_id NUMBER;
19877: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19878: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19879: -- num_customers NUMBER := 0; bug 5622539
19880: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
19881:

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

19874: DECLARE
19875: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;
19876: hghst_ctr_cust_id NUMBER;
19877: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19878: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19879: -- num_customers NUMBER := 0; bug 5622539
19880: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
19881:
19882: l_return_status VARCHAR2(10);