APPS.PSB_WS_ACCT2 dependencies on PSB_BUDGET_YEAR_TYPES

Line 4094: -- Bug#3237740: Added join to PSB_BUDGET_YEAR_TYPES.

4090: where entity_id = p_parameter_id
4091: and entity_subtype = 'ACCOUNT';
4092:
4093: -- Bug#1584464: Note_id column added.
4094: -- Bug#3237740: Added join to PSB_BUDGET_YEAR_TYPES.
4095: -- Bug#3570461: currency_code column added.
4096: CURSOR c_AcctLine IS
4097: select b.account_line_id,
4098: b.code_combination_id,

Line 4111: PSB_BUDGET_YEAR_TYPES d

4107: c.name -- Bug#4571412
4108: FROM PSB_WS_LINES a,
4109: PSB_WS_ACCOUNT_LINES b,
4110: PSB_BUDGET_PERIODS c,
4111: PSB_BUDGET_YEAR_TYPES d
4112: WHERE a.worksheet_id = p_worksheet_id
4113: AND b.account_line_id = a.account_line_id
4114: AND b.end_stage_seq is null
4115: AND b.balance_type = 'E'

Line 5761: FROM PSB_BUDGET_YEAR_TYPES

5757:
5758: /* Bug No 2354918 Start */
5759: CURSOR c_budyr_type IS
5760: SELECT year_category_type
5761: FROM PSB_BUDGET_YEAR_TYPES
5762: WHERE budget_year_type_id = p_budget_year_type_id;
5763: /* Bug No 2354918 End */
5764:
5765: l_running_total NUMBER := 0;