DBA Data[Home] [Help]

APPS.PSB_WS_ACCT1 dependencies on PSB_WS_ACCOUNT_LINES_S

Line 2292: values (psb_ws_account_lines_s.nextval,

2288: period43_amount, period44_amount, period45_amount, period46_amount, period47_amount, period48_amount,
2289: period49_amount, period50_amount, period51_amount, period52_amount, period53_amount, period54_amount,
2290: period55_amount, period56_amount, period57_amount, period58_amount, period59_amount, period60_amount,
2291: ytd_amount, request_id, functional_transaction)
2292: values (psb_ws_account_lines_s.nextval,
2293: l_ccid,
2294: decode(p_position_line_id, FND_API.G_MISS_NUM, null, p_position_line_id),
2295: l_service_package_id,
2296: p_budget_group_id,

Line 2654: select PSB_WS_ACCOUNT_LINES_S.NEXTVAL seq

2650: and a.account_position_set_id = c.account_position_set_id
2651: and c.code_combination_id = l_ccid;
2652: --
2653: cursor c_seq is
2654: select PSB_WS_ACCOUNT_LINES_S.NEXTVAL seq
2655: from dual;
2656:
2657: -- Bug No 2354918 Start
2658: cursor c_WAL is

Line 3937: UPDATE psb_ws_account_lines SET budget_group_changed = 'Y'

3933: FROM PSB_WS_LINES_POSITIONS
3934: WHERE position_line_id = l_position_line_id;
3935:
3936: /* Start bug #4167811 */
3937: UPDATE psb_ws_account_lines SET budget_group_changed = 'Y'
3938: WHERE account_line_id = p_account_line_id;
3939: /* End bug #4167811 */
3940: END;
3941: