eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_PI_IMPORT_DATA dependencies on DUAL

Line 435: from DUAL;

431:
432: -- Insert Payroll Control Records into PSP_Payroll_Controls table
433: Select PSP_PAYROLL_CONTROLS_S.NextVal
434: into n_Payroll_Control_ID
435: from DUAL;
436:
437: PSP_PAYROLL_CONTROLS_PKG.INSERT_ROW (
438: X_ROWID => v_ROWID,
439: X_PAYROLL_CONTROL_ID => n_Payroll_Control_ID,

Line 616: -- obtain the primary key for the PSP_PAYROLL_LINES table from the DUAL table

612: where a.PAYROLL_ID = n_Payroll_ID
613: and d_Effective_Date BETWEEN a.EFFECTIVE_START_DATE AND a.EFFECTIVE_END_DATE
614: and a.business_group_id = v_business_group_id;
615:
616: -- obtain the primary key for the PSP_PAYROLL_LINES table from the DUAL table
617: select PSP_PAYROLL_LINES_S.NextVal
618: into n_Payroll_Lines_ID
619: from DUAL;
620:

Line 619: from DUAL;

615:
616: -- obtain the primary key for the PSP_PAYROLL_LINES table from the DUAL table
617: select PSP_PAYROLL_LINES_S.NextVal
618: into n_Payroll_Lines_ID
619: from DUAL;
620:
621: /*********************************************************************************************
622: -- Commented out the following code bcos we no longer want to obtain GL_CCID from the complex
623: -- procedure below. Instead, we want to obtain GL_CCID from PSP_Clearing_Account (Venkat 06/24)

Line 784: -- Obtain the primary key for the PSP_PAYROLL_SUB_LINES table from DUAL

780: l_attribute10 VARCHAR2(150);
781: BEGIN
782: FOR Sub_Lines_Record_Agg IN Sub_Lines_Record LOOP
783: -- The Payroll Lines ID key is the current value of n_Payroll_Lines_ID
784: -- Obtain the primary key for the PSP_PAYROLL_SUB_LINES table from DUAL
785: select PSP_PAYROLL_SUB_LINES_S.nextval
786: into n_Payroll_Sub_Lines_ID
787: from DUAL;
788: -- Insert records to the PSP_PAYROLL_SUB_LINES table

Line 787: from DUAL;

783: -- The Payroll Lines ID key is the current value of n_Payroll_Lines_ID
784: -- Obtain the primary key for the PSP_PAYROLL_SUB_LINES table from DUAL
785: select PSP_PAYROLL_SUB_LINES_S.nextval
786: into n_Payroll_Sub_Lines_ID
787: from DUAL;
788: -- Insert records to the PSP_PAYROLL_SUB_LINES table
789: -- Leave Organization_ID, Job_ID, Position_ID, Employment_Begin_Date,
790: -- dbms_output.put_line('Inserting into payroll sub lines table');
791: -- Employment_End_Date, Assignment Date, etc empty (Venkat 03/19/98)