DBA Data[Home] [Help]

APPS.PSB_WS_POS1 dependencies on DUAL

Line 52: from dual;

48: where budget_group_id = BudGrp;
49:
50: cursor c_FTESeq is
51: select psb_ws_fte_lines_s.nextval FteLineID
52: from dual;
53:
54: cursor c_BaseSP (GlobalWS NUMBER) is
55: select service_package_id
56: from PSB_SERVICE_PACKAGES

Line 1322: from dual;

1318: and b.position_id = p_position_id;
1319:
1320: cursor c_Seq is
1321: select psb_ws_position_lines_s.nextval PosLineID
1322: from dual;
1323:
1324: BEGIN
1325:
1326: -- Standard call to check for call compatibility

Line 3624: from dual;

3620: l_msg_count NUMBER;
3621:
3622: cursor c_Seq is
3623: select psb_ws_element_lines_s.nextval ElmLineID
3624: from dual;
3625:
3626: cursor c_Wel_SP is
3627: select element_line_id,
3628: element_cost

Line 3845: from dual;

3841: l_msg_count NUMBER;
3842:
3843: cursor c_ElmSeq is
3844: select psb_ws_element_lines_s.nextval ElmLineID
3845: from dual;
3846:
3847: cursor c_PrevStage is
3848: select Max(sequence_number) sequence_number
3849: from PSB_BUDGET_STAGES