DBA Data[Home] [Help]

APPS.PA_CALC_OVERTIME dependencies on DUAL

Line 403: from sys.dual;

399:
400: -- Sel_Overtime_Expend_Group_Name()
401: select 'PREMIUM - ' || to_char(R_P_Request_ID)
402: into overtime_expenditure_group
403: from sys.dual;
404: -- Insert_Expenditure_Group()
405: Pa_Transactions.InsertExpGroup(
406: Overtime_Expenditure_Group
407: ,'RELEASED'

Line 419: select PA_EXPENDITURES_S.NEXTVAL INTO Expenditure_ID FROM sys.dual;

415: END IF;
416:
417: IF Exp_Created_Flag <> 'Y' THEN
418: -- Sel_Expenditure_ID()
419: select PA_EXPENDITURES_S.NEXTVAL INTO Expenditure_ID FROM sys.dual;
420:
421: Pa_Transactions.InsertExp(
422: X_expenditure_id => Expenditure_ID,
423: X_expend_status => 'APPROVED',

Line 583: from sys.dual;

579:
580: -- insert_exp_item()
581: select PA_EXPENDITURE_ITEMS_S.NEXTVAL
582: into X_expenditure_item_id
583: from sys.dual;
584:
585: /*
586: Multi-currency related changes:
587: Pass Txn, Functional and Project currency