APPS.PSB_POSITIONS_PVT dependencies on PSB_DEFAULTS

Line 3144: PSB_DEFAULTS b,

3140: a.element_value_type,
3141: a.element_value,
3142: a.currency_code
3143: FROM PSB_DEFAULT_ASSIGNMENTS a,
3144: PSB_DEFAULTS b,
3145: PSB_SET_RELATIONS c,
3146: PSB_BUDGET_POSITIONS d
3147: WHERE a.default_rule_id = b.default_rule_id
3148: AND b.priority is not null

Line 3180: psb_defaults b,

3176: a.element_value_type,
3177: a.element_value,
3178: a.currency_code
3179: FROM psb_default_assignments a,
3180: psb_defaults b,
3181: psb_set_relations c,
3182: psb_budget_positions d,
3183: psb_entity_set e,
3184: psb_entity_assignment f

Line 3212: psb_defaults b,

3208: a.element_value_type,
3209: a.element_value,
3210: a.currency_code
3211: FROM psb_default_assignments a,
3212: psb_defaults b,
3213: psb_entity_set c,
3214: psb_entity_assignment d
3215: WHERE a.default_rule_id = b.default_rule_id
3216: AND b.global_default_flag = 'Y'

Line 3383: FROM PSB_DEFAULTS a,

3379: CURSOR c_Priority IS
3380: SELECT a.default_rule_id,
3381: a.priority,
3382: a.global_default_flag
3383: FROM PSB_DEFAULTS a,
3384: PSB_SET_RELATIONS b,
3385: PSB_BUDGET_POSITIONS c
3386: WHERE EXISTS
3387: (SELECT 1

Line 3412: FROM psb_defaults a,

3408: SELECT a.default_rule_id,
3409: f.priority priority,
3410: a.global_default_flag,
3411: a.overwrite
3412: FROM psb_defaults a,
3413: psb_set_relations b,
3414: psb_budget_positions c,
3415: psb_entity_set e,
3416: psb_entity_assignment f

Line 3436: FROM psb_defaults a,

3432: SELECT a.default_rule_id,
3433: c.priority priority,
3434: a.global_default_flag,
3435: a.overwrite
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

Line 3512: PSB_DEFAULTS b

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);
3516: FETCH l_global_dist_csr INTO l_exists;

Line 3601: PSB_DEFAULTS b

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
3605: AND a.default_rule_id = l_default_rule_id

Line 3735: PSB_DEFAULTS b,

3731: a.element_value_type,
3732: a.element_value,
3733: a.currency_code
3734: from PSB_DEFAULT_ASSIGNMENTS a,
3735: PSB_DEFAULTS b,
3736: PSB_SET_RELATIONS c,
3737: PSB_BUDGET_POSITIONS d
3738: where EXISTS
3739: ( select 1

Line 3865: PSB_DEFAULTS b

3861: a.element_value_type,
3862: a.element_value,
3863: a.currency_code
3864: from PSB_DEFAULT_ASSIGNMENTS a,
3865: PSB_DEFAULTS b
3866: where a.default_rule_id = b.default_rule_id
3867: and b.global_default_flag = 'Y'
3868: and b.data_extract_id = p_data_extract_id;
3869:

Line 3876: PSB_DEFAULTS b

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;
3880: