DBA Data[Home] [Help]

APPS.PA_RETN_BILLING_PKG dependencies on PA_PROJ_RETN_BILL_RULES

Line 1288: pa_proj_retn_bill_rules rt

1284: */
1285: FROM pa_project_customers pc, pa_projects_all pr, hz_parties hz_p, hz_cust_accounts hz_c
1286: WHERE EXISTS(
1287: SELECT NULL FROM pa_summary_project_retn spr,
1288: pa_proj_retn_bill_rules rt
1289: WHERE rt.project_id = spr.project_id
1290: AND rt.customer_id = spr.customer_id
1291: AND spr.customer_id = pc.customer_id
1292: AND spr.project_id = pc.project_id

Line 1341: FROM pa_proj_retn_bill_rules retn1,

1337: retn1.client_extension_flag client_extn_flag,
1338: cy.billing_cycle_name billing_cycle_name,
1339: lk.meaning billingMethodDesc,
1340: retn1.task_id task_id
1341: FROM pa_proj_retn_bill_rules retn1,
1342: pa_billing_cycles cy,
1343: pa_lookups lk
1344: WHERE retn1.project_id = TmpProjectId
1345: AND retn1.customer_id= TmpCustomerId

Line 1362: FROM pa_proj_retn_bill_rules retn,

1358: retn.client_extension_flag client_extn_flag,
1359: 'NULL' billing_cycle_name,
1360: lk.meaning billingMethodDesc,
1361: retn.task_id task_id
1362: FROM pa_proj_retn_bill_rules retn,
1363: pa_lookups lk
1364: WHERE retn.project_id = TmpProjectId
1365: AND retn.customer_id= TmpCustomerId
1366: AND lk.lookup_code = retn.billing_method_code