3384: PSB_SET_RELATIONS b,
3385: PSB_BUDGET_POSITIONS c
3386: WHERE EXISTS
3387: (SELECT 1
3388: FROM PSB_DEFAULT_ACCOUNT_DISTRS d
3389: WHERE d.default_rule_id = a.default_rule_id)
3390: AND a.priority is not null
3391: AND a.default_rule_id = b.default_rule_id
3392: AND b.account_position_set_id = c.account_position_set_id
3415: psb_entity_set e,
3416: psb_entity_assignment f
3417: WHERE EXISTS -- Bug 4226623 added the exists clause
3418: (SELECT 1
3419: FROM PSB_DEFAULT_ACCOUNT_DISTRS d
3420: WHERE d.default_rule_id = a.default_rule_id)
3421: -- AND f.priority is not null
3422: AND a.default_rule_id = b.default_rule_id
3423: AND b.account_position_set_id = c.account_position_set_id
3436: FROM psb_defaults a,
3437: psb_entity_set b,
3438: psb_entity_assignment c
3439: WHERE EXISTS (SELECT 1
3440: FROM PSB_DEFAULT_ACCOUNT_DISTRS d
3441: WHERE d.default_rule_id = a.default_rule_id)
3442: AND a.global_default_flag = 'Y'
3443: AND a.data_extract_id = p_data_extract_id
3444: AND b.entity_set_id = c.entity_set_id
3457: cursor c_Dist is
3458: select chart_of_accounts_id,
3459: code_combination_id,
3460: distribution_percent
3461: from PSB_DEFAULT_ACCOUNT_DISTRS
3462: where default_rule_id = l_default_rule_id;
3463:
3464: CURSOR l_distribution_id_csr
3465: IS
3507: SELECT 'Exists'
3508: FROM dual
3509: WHERE EXISTS
3510: (SELECT 1
3511: FROM PSB_DEFAULT_ACCOUNT_DISTRS a,
3512: PSB_DEFAULTS b
3513: WHERE a.default_rule_id = b.default_rule_id
3514: AND b.global_default_flag = 'Y'
3515: AND b.data_extract_id = p_data_extract_id);
3596: SELECT 'Exists'
3597: FROM dual
3598: WHERE EXISTS
3599: (SELECT 1
3600: FROM PSB_DEFAULT_ACCOUNT_DISTRS a,
3601: PSB_DEFAULTS b
3602: WHERE a.default_rule_id = b.default_rule_id
3603: AND b.global_default_flag = 'Y'
3604: AND b.data_extract_id = p_data_extract_id
3871: select a.default_rule_id,
3872: a.chart_of_accounts_id,
3873: a.code_combination_id,
3874: a.distribution_percent
3875: from PSB_DEFAULT_ACCOUNT_DISTRS a,
3876: PSB_DEFAULTS b
3877: where a.default_rule_id = b.default_rule_id
3878: and b.global_default_flag = 'Y'
3879: and b.data_extract_id = p_data_extract_id;