DBA Data[Home] [Help]

APPS.PA_CANDIDATE_PUB dependencies on PA_PROJECT_CUSTOMERS

Line 1829: FROM pa_project_customers ppc,

1825:
1826: /*
1827: CURSOR project_customers IS
1828: SELECT ppc.customer_id,rac.customer_name
1829: FROM pa_project_customers ppc,
1830: ra_customers rac
1831: WHERE ppc.project_id = p_project_id
1832: AND rac.customer_id = ppc.customer_id ;
1833: */

Line 1837: FROM pa_project_customers ppc,

1833: */
1834:
1835: CURSOR project_customers IS
1836: SELECT ppc.customer_id, substrb(party.party_name,1,50) customer_name
1837: FROM pa_project_customers ppc,
1838: hz_parties party,
1839: hz_cust_accounts cust_acct
1840: WHERE ppc.project_id = p_project_id
1841: AND cust_acct.cust_account_id = ppc.customer_id