APPS.PA_RETN_BILLING_PKG dependencies on PA_LOOKUPS

Line 533: FROM pa_lookups lk

529: END IF;
530:
531: SELECT lk.meaning
532: INTO TmpWarningMsg
533: FROM pa_lookups lk
534: WHERE lk.lookup_code = TmpWarningCode
535: AND lk.lookup_type = 'INVOICE DISTRIBUTION WARNING';
536:
537: IF g1_debug_mode = 'Y' THEN

Line 1343: pa_lookups lk

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
1346: AND lk.lookup_code = retn1.billing_method_code
1347: AND lk.lookup_type ='RETN_BILLING_METHOD'

Line 1363: pa_lookups lk

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
1367: AND lk.lookup_type ='RETN_BILLING_METHOD'

Line 2044: FROM pa_lookups lk

2040: END IF;
2041:
2042: SELECT lk.meaning
2043: INTO TmpWarningMsg
2044: FROM pa_lookups lk
2045: WHERE lk.lookup_code = TmpWarningCode
2046: AND lk.lookup_type = 'INVOICE DISTRIBUTION WARNING';
2047:
2048: IF g1_debug_mode = 'Y' THEN