APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_PARAMETER_ASSIGNMENTS_V

Line 1233: from PSB_PARAMETER_ASSIGNMENTS_V a

1229: l_account_exists BOOLEAN := FALSE;
1230:
1231: cursor c_Exists is
1232: select 'Exists'
1233: from PSB_PARAMETER_ASSIGNMENTS_V a
1234: where p_local_parameter = 'N'
1235: and parameter_set_id = g_parameter_set_id
1236: and parameter_id = p_parameter_id
1237: and exists

Line 2570: from PSB_PARAMETER_ASSIGNMENTS_V

2566: parameter_compound_annually,
2567: currency_code,
2568: effective_start_date,
2569: effective_end_date
2570: from PSB_PARAMETER_ASSIGNMENTS_V
2571: where p_local_parameter = 'N'
2572: and data_extract_id = g_data_extract_id
2573: and parameter_type = 'ELEMENT'
2574: and (((effective_start_date <= p_revision_end_date)

Line 2778: from PSB_PARAMETER_ASSIGNMENTS_V

2774: parameter_compound_annually,
2775: currency_code,
2776: effective_start_date,
2777: effective_end_date
2778: from PSB_PARAMETER_ASSIGNMENTS_V
2779: where p_local_parameter = 'N'
2780: and parameter_autoinc_rule = 'N'
2781: and data_extract_id = g_data_extract_id
2782: and parameter_type = 'POSITION'

Line 2820: from PSB_PARAMETER_ASSIGNMENTS_V

2816: parameter_compound_annually,
2817: currency_code,
2818: effective_start_date,
2819: effective_end_date
2820: from PSB_PARAMETER_ASSIGNMENTS_V
2821: where p_local_parameter = 'N'
2822: and parameter_autoinc_rule = 'Y'
2823: and data_extract_id = g_data_extract_id
2824: and parameter_type = 'POSITION'

Line 3165: from PSB_PARAMETER_ASSIGNMENTS_V

3161: effective_end_date,
3162: priority priority,
3163: parameter_compound_annually,
3164: currency_code
3165: from PSB_PARAMETER_ASSIGNMENTS_V
3166: where l_parameter_id is null
3167: and parameter_set_id = g_parameter_set_id
3168: and parameter_type = 'ACCOUNT'
3169: and NVL(currency_code, g_currency_code) = g_currency_code