DBA Data[Home] [Help]

APPS.PA_CANDIDATE_PUB dependencies on PA_PROJECT_CUSTOMERS

Line 1575: FROM pa_project_customers ppc,

1571:
1572: /*
1573: CURSOR project_customers IS
1574: SELECT ppc.customer_id,rac.customer_name
1575: FROM pa_project_customers ppc,
1576: ra_customers rac
1577: WHERE ppc.project_id = p_project_id
1578: AND rac.customer_id = ppc.customer_id ;
1579: */

Line 1583: FROM pa_project_customers ppc,

1579: */
1580:
1581: CURSOR project_customers IS
1582: SELECT ppc.customer_id, substrb(party.party_name,1,50) customer_name
1583: FROM pa_project_customers ppc,
1584: hz_parties party,
1585: hz_cust_accounts cust_acct
1586: WHERE ppc.project_id = p_project_id
1587: AND cust_acct.cust_account_id = ppc.customer_id