APPS.PAY_CA_PAYRG_PKG dependencies on PAY_US_RPT_TOTALS

Line 511: insert into pay_us_rpt_totals

507: close c_taxgrp_max_run_aaid;
508:
509: if prev_assignment_id <> 0 then
510:
511: insert into pay_us_rpt_totals
512: (session_id,
513: tax_unit_id,
514: location_id,
515: value1,

Line 602: insert into pay_us_rpt_totals

598: exception when others then
599: null;
600: end;
601:
602: insert into pay_us_rpt_totals
603: (session_id,
604: tax_unit_id,
605: location_id,
606: value1,

Line 645: insert into pay_us_rpt_totals

641:
642: hr_utility.trace('ln_action_sequence= '||ln_action_sequence);
643: hr_utility.trace('ln_map_max_aaid= '||ln_map_max_aaid);
644:
645: insert into pay_us_rpt_totals
646: (session_id,
647: tax_unit_id,
648: location_id,
649: value1,

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

662: else
663:
664: if lv_pyrl_arch_lvl = 'GRE' then
665:
666: -- Insert a row in pay_us_rpt_totals which includes
667: -- payroll_action_id,
668: -- report created assignment_action_id (lockingactid)
669: -- and "payroll run" assignment_action id.
670:

Line 671: insert into pay_us_rpt_totals

667: -- payroll_action_id,
668: -- report created assignment_action_id (lockingactid)
669: -- and "payroll run" assignment_action id.
670:
671: insert into pay_us_rpt_totals
672: (session_id,
673: tax_unit_id,
674: location_id,
675: value1,

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

723: exception when others then
724: null;
725: end;
726:
727: -- Insert a row in pay_us_rpt_totals which includes
728: -- payroll_action_id,
729: -- report created assignment_action_id (lockingactid)
730: -- and "payroll run" assignment_action id.
731:

Line 732: insert into pay_us_rpt_totals

728: -- payroll_action_id,
729: -- report created assignment_action_id (lockingactid)
730: -- and "payroll run" assignment_action id.
731:
732: insert into pay_us_rpt_totals
733: (session_id,
734: tax_unit_id,
735: location_id,
736: value1)