APPS.CZ_LC_MGR dependencies on CZ_LCE_HEADERS

Line 65: CZ_BASE_MGR.exec('CZ_LCE_HEADERS','where deleted_flag='''||'0'||''' AND '||

61: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
62:
63: PROCEDURE Propogate_DeletedFlag IS
64: BEGIN
65: CZ_BASE_MGR.exec('CZ_LCE_HEADERS','where deleted_flag='''||'0'||''' AND '||
66: 'component_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
67: 'lce_header_id',FALSE);
68:
69: CZ_BASE_MGR.exec('CZ_LCE_LOAD_SPECS','where deleted_flag='''||'0'||''' AND '||

Line 70: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',

66: 'component_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
67: 'lce_header_id',FALSE);
68:
69: CZ_BASE_MGR.exec('CZ_LCE_LOAD_SPECS','where deleted_flag='''||'0'||''' AND '||
70: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
71: 'lce_header_id','attachment_expl_id','required_expl_id',FALSE);
72:
73: CZ_BASE_MGR.exec('CZ_LCE_TEXTS','where '||
74: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',

Line 74: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',

70: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
71: 'lce_header_id','attachment_expl_id','required_expl_id',FALSE);
72:
73: CZ_BASE_MGR.exec('CZ_LCE_TEXTS','where '||
74: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
75: 'lce_header_id','seq_nbr',TRUE);
76: END;
77:
78: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 158: FROM cz_lce_headers

154: SELECT lce_header_id,
155: desc_text,
156: component_id,
157: gen_version
158: FROM cz_lce_headers
159: WHERE Lce_header_id = p_lce_header_id;
160:
161: CURSOR lines_cursor(p_lce_header_id NUMBER) IS
162: SELECT lce_line_id,