APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_LOOKUPS

Line 4762: FROM PA_LOOKUPS

4758: ,pra.transaction_source_code
4759: ,pra.planning_end_date
4760: ,decode(pra.transaction_source_code,NULL,NULL,
4761: (SELECT meaning
4762: FROM PA_LOOKUPS
4763: WHERE LOOKUP_TYPE='PA_FP_FCST_GEN_SRC_ALL'
4764: AND LOOKUP_CODE= pra.transaction_source_code)) etc_source
4765: BULK COLLECT INTO
4766: l_ra_id_tbl_1

Line 4815: FOR C1 IN (select lookup_code, meaning from pa_lookups where lookup_type = 'PA_FP_FCST_GEN_CLNT_EXTN_LU') loop

4811:
4812: IF l_ra_id_tbl_1.COUNT > 0 THEN
4813:
4814:
4815: FOR C1 IN (select lookup_code, meaning from pa_lookups where lookup_type = 'PA_FP_FCST_GEN_CLNT_EXTN_LU') loop
4816: l_description_tbl(c1.lookup_code) := c1.meaning;
4817: END LOOP;
4818:
4819: