APPS.GMD_SPREAD_FETCH_PKG dependencies on FND_FOLDERS

Line 752: FROM fnd_folders a, fnd_folder_columns b, lm_tech_hdr c

748: l_count NUMBER;
749:
750: /*CURSOR Cur_get_folder_cols IS
751: SELECT c.*, b.sequence
752: FROM fnd_folders a, fnd_folder_columns b, lm_tech_hdr c
753: WHERE a.folder_id = b.folder_id
754: AND b.item_prompt = c.tech_parm_name
755: AND a.name = V_folder_name
756: AND a.OBJECT = 'SPREAD_DTL_SUB'

Line 763: FROM fnd_folders a,

759: -- Bug: 7006219 Vpedarla Modified the cursor Cur_get_folder_cols to get the default organization tech. parameters sequence
760: -- if item parameters sequence is not defined.
761: CURSOR Cur_get_folder_cols IS
762: SELECT c.*, b.sequence
763: FROM fnd_folders a,
764: fnd_folder_columns b, lm_tech_hdr c, gmd_technical_sequence_vl s
765: WHERE a.folder_id(+) = b.folder_id
766: AND c.tech_parm_name = b.item_prompt(+)
767: AND a.name(+) = V_folder_name --- Bug 4254315 ....

Line 776: FROM fnd_folders a,

772: AND NVL(l_item_id, 1) = NVL(s.inventory_item_id,1)
773: AND NVL(s.category_id, 1) = NVL(l_category_id ,1)
774: UNION
775: SELECT c.*, b.sequence
776: FROM fnd_folders a,
777: fnd_folder_columns b, lm_tech_hdr c, gmd_technical_sequence_vl s
778: WHERE a.folder_id(+) = b.folder_id
779: AND c.tech_parm_name = b.item_prompt(+)
780: AND a.name(+) = V_folder_name --- Bug 4254315 ....