APPS.PAY_US_MARK_W2C_PAPER dependencies on PAY_US_RPT_TOTALS

Line 520: insert into pay_us_rpt_totals

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

Line 766: FROM pay_us_rpt_totals

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

Line 868: DELETE FROM pay_us_rpt_totals

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