APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_LOOKUPS

Line 4786: FROM PA_LOOKUPS

4782: ,pra.transaction_source_code
4783: ,pra.planning_end_date
4784: ,decode(pra.transaction_source_code,NULL,NULL,
4785: (SELECT meaning
4786: FROM PA_LOOKUPS
4787: WHERE LOOKUP_TYPE='PA_FP_FCST_GEN_SRC_ALL'
4788: AND LOOKUP_CODE= pra.transaction_source_code)) etc_source
4789: BULK COLLECT INTO
4790: l_ra_id_tbl_1

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

4835:
4836: IF l_ra_id_tbl_1.COUNT > 0 THEN
4837:
4838:
4839: FOR C1 IN (select lookup_code, meaning from pa_lookups where lookup_type = 'PA_FP_FCST_GEN_CLNT_EXTN_LU') loop
4840: l_description_tbl(c1.lookup_code) := c1.meaning;
4841: END LOOP;
4842:
4843: