DBA Data[Home] [Help]

APPS.JTM_CON_QUERY_REQUEST_PKG dependencies on JTM_FND_DESC_FLEX_COL_USG_ACC

Line 74: from JTM_FND_DESC_FLEX_COL_USG_ACC

70:
71: Cursor get_old_col_usg_acc (
72: p_creation_date date, p_appl_id number, p_dff_name in varchar2) is
73: select access_id
74: from JTM_FND_DESC_FLEX_COL_USG_ACC
75: where creation_date < p_creation_date
76: and APPLICATION_ID = p_appl_id
77: and DESCRIPTIVE_FLEXFIELD_NAME = p_dff_name;
78:

Line 259: Update JTM_FND_DESC_FLEX_COL_USG_ACC

255: p_dml => 'I',
256: p_timestamp => sysdate );
257: END LOOP;
258:
259: Update JTM_FND_DESC_FLEX_COL_USG_ACC
260: set creation_date = c_seed_date.creation_date
261: where access_id = c_old_col_usg_acc.access_id;
262:
263: commit;