APPS.ZPB_ACVAL_PVT dependencies on ZPB_CYCLE_DATASETS

Line 85: from zpb_cycle_datasets pub

81:
82:
83: cursor data_set is
84: select '1'
85: from zpb_cycle_datasets pub
86: where pub.analysis_cycle_id = l_pub_ac_id
87: and pub.dataset_code not in (select edt.dataset_code
88: from zpb_cycle_datasets edt
89: where edt.analysis_cycle_id = l_edt_ac_id

Line 88: from zpb_cycle_datasets edt

84: select '1'
85: from zpb_cycle_datasets pub
86: where pub.analysis_cycle_id = l_pub_ac_id
87: and pub.dataset_code not in (select edt.dataset_code
88: from zpb_cycle_datasets edt
89: where edt.analysis_cycle_id = l_edt_ac_id
90: and edt.order_id = pub.order_id
91: )
92: union

Line 94: from zpb_cycle_datasets edt

90: and edt.order_id = pub.order_id
91: )
92: union
93: select '1'
94: from zpb_cycle_datasets edt
95: where edt.analysis_cycle_id = l_edt_ac_id
96: and edt.dataset_code not in (select pub.dataset_code
97: from zpb_cycle_datasets pub
98: where pub.analysis_cycle_id = l_pub_ac_id

Line 97: from zpb_cycle_datasets pub

93: select '1'
94: from zpb_cycle_datasets edt
95: where edt.analysis_cycle_id = l_edt_ac_id
96: and edt.dataset_code not in (select pub.dataset_code
97: from zpb_cycle_datasets pub
98: where pub.analysis_cycle_id = l_pub_ac_id
99: and edt.order_id = pub.order_id
100: );
101: