APPS.PAY_CA_PAYRG_PKG dependencies on PAY_US_RPT_TOTALS

Line 516: insert into pay_us_rpt_totals

512: close c_taxgrp_max_run_aaid;
513:
514: if prev_assignment_id <> 0 then
515:
516: insert into pay_us_rpt_totals
517: (session_id,
518: tax_unit_id,
519: location_id,
520: value1,

Line 607: insert into pay_us_rpt_totals

603: exception when others then
604: null;
605: end;
606:
607: insert into pay_us_rpt_totals
608: (session_id,
609: tax_unit_id,
610: location_id,
611: value1,

Line 650: insert into pay_us_rpt_totals

646:
647: hr_utility.trace('ln_action_sequence= '||ln_action_sequence);
648: hr_utility.trace('ln_map_max_aaid= '||ln_map_max_aaid);
649:
650: insert into pay_us_rpt_totals
651: (session_id,
652: tax_unit_id,
653: location_id,
654: value1,

Line 671: -- Insert a row in pay_us_rpt_totals which includes

667: else
668:
669: if lv_pyrl_arch_lvl = 'GRE' then
670:
671: -- Insert a row in pay_us_rpt_totals which includes
672: -- payroll_action_id,
673: -- report created assignment_action_id (lockingactid)
674: -- and "payroll run" assignment_action id.
675:

Line 676: insert into pay_us_rpt_totals

672: -- payroll_action_id,
673: -- report created assignment_action_id (lockingactid)
674: -- and "payroll run" assignment_action id.
675:
676: insert into pay_us_rpt_totals
677: (session_id,
678: tax_unit_id,
679: location_id,
680: value1,

Line 732: -- Insert a row in pay_us_rpt_totals which includes

728: exception when others then
729: null;
730: end;
731:
732: -- Insert a row in pay_us_rpt_totals which includes
733: -- payroll_action_id,
734: -- report created assignment_action_id (lockingactid)
735: -- and "payroll run" assignment_action id.
736:

Line 737: insert into pay_us_rpt_totals

733: -- payroll_action_id,
734: -- report created assignment_action_id (lockingactid)
735: -- and "payroll run" assignment_action id.
736:
737: insert into pay_us_rpt_totals
738: (session_id,
739: tax_unit_id,
740: location_id,
741: value1)