APPS.PSB_POSITIONS_I_PVT dependencies on PSB_DEFAULTS

Line 178: psb_defaults b,

174: a.element_value_type,
175: a.element_value,
176: a.currency_code
177: FROM psb_default_assignments a,
178: psb_defaults b,
179: psb_set_relations c,
180: psb_budget_positions d,
181: psb_entity_set e,
182: psb_entity_assignment f

Line 209: psb_defaults b,

205: a.element_value_type,
206: a.element_value,
207: a.currency_code
208: FROM psb_default_assignments a,
209: psb_defaults b,
210: psb_entity_set c,
211: psb_entity_assignment d
212: WHERE a.default_rule_id = b.default_rule_id
213: AND b.global_default_flag = 'Y'

Line 234: FROM psb_defaults a,

230: SELECT a.default_rule_id,
231: f.priority priority,
232: a.global_default_flag,
233: a.overwrite
234: FROM psb_defaults a,
235: psb_set_relations b,
236: psb_budget_positions c,
237: psb_entity_set e,
238: psb_entity_assignment f

Line 257: FROM psb_defaults a,

253: SELECT a.default_rule_id,
254: c.priority priority,
255: a.global_default_flag,
256: a.overwrite
257: FROM psb_defaults a,
258: psb_entity_set b,
259: psb_entity_assignment c
260: WHERE EXISTS (SELECT 1
261: FROM PSB_DEFAULT_ACCOUNT_DISTRS d

Line 278: PSB_DEFAULTS b

274: FROM dual
275: WHERE EXISTS
276: (SELECT 1
277: FROM PSB_DEFAULT_ACCOUNT_DISTRS a,
278: PSB_DEFAULTS b
279: WHERE a.default_rule_id = b.default_rule_id
280: AND b.global_default_flag = 'Y'
281: AND b.data_extract_id = p_data_extract_id
282: AND a.default_rule_id = l_default_rule_id