APPS.PAY_US_MARK_W2C_PAPER dependencies on PAY_US_RPT_TOTALS

Line 518: insert into pay_us_rpt_totals

514: ,lp_assignment_action_id);
515: hr_utility.set_location(gv_package || '.action_creation', 40);
516:
517:
518: insert into pay_us_rpt_totals
519: (GRE_NAME,
520: STATE_NAME,
521: ATTRIBUTE1, -- FULL_NAME
522: ATTRIBUTE2, -- NATIONAL_IDENTIFIER

Line 764: FROM pay_us_rpt_totals

760: attribute4, -- assignment_number,
761: attribute6, -- year
762: attribute7, -- PAPER_CREATION_DATE
763: attribute8 -- Sysdate
764: FROM pay_us_rpt_totals
765: WHERE state_name = 'MARKW2C_PROCESS'
766: AND session_id = to_number(c_seq_num)
767: ORDER BY attribute6,gre_name, attribute1,attribute4,attribute5;
768:

Line 866: DELETE FROM pay_us_rpt_totals

862: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
863: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
864: end if;
865:
866: DELETE FROM pay_us_rpt_totals
867: WHERE session_id = to_number(p_seq_num);
868:
869: END select_ee_details;
870: