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.HR_RUNGEN dependencies on PAY_PAYROLL_ACTIONS

Line 612: from pay_payroll_actions

608: l_errbuf varchar2(240);
609: --
610: cursor retactions is
611: select payroll_action_id
612: from pay_payroll_actions
613: where target_payroll_action_id = p_primary_action_id
614: and payroll_id = p_payroll_id
615: and action_type = 'R'
616: and effective_date = fnd_date.canonical_to_date(p_date_paid)

Line 650: from pay_payroll_actions

646: is
647: --
648: cursor retactions is
649: select payroll_action_id
650: from pay_payroll_actions
651: where target_payroll_action_id = p_primary_action_id
652: and payroll_id = p_payroll_id
653: and action_type = 'R'
654: and effective_date = fnd_date.canonical_to_date(p_date_paid)

Line 682: pay_payroll_actions ppa,

678: select distinct asg2.payroll_action_id
679: into l_prepay_id
680: from pay_assignment_actions asg2,
681: pay_action_interlocks pai,
682: pay_payroll_actions ppa,
683: pay_assignment_actions asg1
684: where asg1.payroll_action_id = actrec.payroll_action_id
685: and asg1.assignment_action_id = pai.locked_action_id
686: and asg2.assignment_action_id = pai.locking_action_id

Line 700: update pay_payroll_actions

696: when no_data_found then
697: --
698: -- Wow, the prepayment has been rolled back.
699: --
700: update pay_payroll_actions
701: set consolidation_set_id = p_sc_con_set_id
702: where payroll_action_id = actrec.payroll_action_id;
703: --
704: commit;

Line 715: FROM pay_payroll_actions

711: l_errbuf);
712: --
713: SELECT payroll_action_id
714: INTO l_sc_preact_id
715: FROM pay_payroll_actions
716: WHERE request_id = l_req_id
717: AND payroll_id = p_payroll_id
718: AND action_type = 'P'
719: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

Line 721: update pay_payroll_actions

717: AND payroll_id = p_payroll_id
718: AND action_type = 'P'
719: AND effective_date = fnd_date.canonical_to_date(p_date_paid);
720: --
721: update pay_payroll_actions
722: set consolidation_set_id = p_master_con_set_id
723: where payroll_action_id = actrec.payroll_action_id;
724: --
725: update pay_payroll_actions

Line 725: update pay_payroll_actions

721: update pay_payroll_actions
722: set consolidation_set_id = p_master_con_set_id
723: where payroll_action_id = actrec.payroll_action_id;
724: --
725: update pay_payroll_actions
726: set consolidation_set_id = p_master_con_set_id,
727: target_payroll_action_id = p_primary_action_id
728: where payroll_action_id = l_sc_preact_id;
729: --

Line 825: FROM pay_payroll_actions

821: l_errbuf);
822: --
823: SELECT payroll_action_id
824: INTO l_sc_payact_id
825: FROM pay_payroll_actions
826: WHERE request_id = l_req_id
827: AND payroll_id = p_payroll_id
828: AND action_type = 'R'
829: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

Line 840: FROM pay_payroll_actions

836: l_errbuf);
837: --
838: SELECT payroll_action_id
839: INTO l_sc_preact_id
840: FROM pay_payroll_actions
841: WHERE request_id = l_req_id
842: AND payroll_id = p_payroll_id
843: AND action_type = 'P'
844: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

Line 847: UPDATE pay_payroll_actions

843: AND action_type = 'P'
844: AND effective_date = fnd_date.canonical_to_date(p_date_paid);
845: --
846: -- Update the actions with the new details.
847: UPDATE pay_payroll_actions
848: SET consolidation_set_id = p_consolidation_set_id,
849: assignment_set_id = NULL,
850: target_payroll_action_id = p_primary_action_id
851: WHERE payroll_action_id = l_sc_payact_id;

Line 853: UPDATE pay_payroll_actions

849: assignment_set_id = NULL,
850: target_payroll_action_id = p_primary_action_id
851: WHERE payroll_action_id = l_sc_payact_id;
852: --
853: UPDATE pay_payroll_actions
854: SET consolidation_set_id = p_consolidation_set_id,
855: target_payroll_action_id = p_primary_action_id
856: WHERE payroll_action_id = l_sc_preact_id;
857: --

Line 937: FROM pay_payroll_actions

933: --
934: --
935: SELECT payroll_action_id
936: INTO l_ts_payact_id
937: FROM pay_payroll_actions
938: WHERE request_id = l_req_id
939: AND payroll_id = p_payroll_id
940: AND action_type = 'R'
941: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

Line 944: UPDATE pay_payroll_actions

940: AND action_type = 'R'
941: AND effective_date = fnd_date.canonical_to_date(p_date_paid);
942: --
943: -- Update the actions with the new details.
944: UPDATE pay_payroll_actions
945: SET assignment_set_id = NULL,
946: target_payroll_action_id = p_primary_action_id
947: WHERE payroll_action_id = l_ts_payact_id;
948: --

Line 1030: FROM pay_payroll_actions

1026: -- Need to get payroll_action_id of primary GTN just submitted.
1027: --
1028: SELECT payroll_action_id
1029: INTO l_payact_id
1030: FROM pay_payroll_actions
1031: WHERE request_id = l_req_id
1032: AND payroll_id = p_payroll_id
1033: AND action_type = 'R'
1034: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

Line 1041: UPDATE pay_payroll_actions

1037: --
1038: -- Update payroll action with pay advice message.
1039: IF p_pay_advice_message IS NOT NULL THEN
1040: --
1041: UPDATE pay_payroll_actions
1042: SET pay_advice_message = p_pay_advice_message
1043: WHERE payroll_action_id = l_payact_id;
1044: --
1045: END IF;

Line 1071: from pay_payroll_actions

1067: l_date_paid,
1068: l_assignment_set_id,
1069: l_ele_set_id,
1070: l_business_group_id
1071: from pay_payroll_actions
1072: where payroll_action_id = l_primary_action;
1073: --
1074: perform_retry(l_primary_action,
1075: l_req_id,

Line 1130: UPDATE pay_payroll_actions

1126: BEGIN
1127: --
1128: hr_utility.set_location('hr_rungen.Del_Asg_Amends', 7);
1129: /*
1130: UPDATE pay_payroll_actions
1131: SET assignment_set_id = NULL
1132: WHERE assignment_set_id = p_assignment_set_id;
1133: */
1134: --