APPS.PAY_RETRO_PKG dependencies on PAY_RETRO_ASSIGNMENTS

Line 648: from pay_retro_assignments pra,

644: --
645:
646: select min(pra.reprocess_date)
647: into l_reprocess_start_date
648: from pay_retro_assignments pra,
649: pay_payroll_actions ppa,
650: pay_assignment_actions paa_ret,
651: pay_assignment_actions paa_mret
652: where ppa.effective_date between p_start_date

Line 1058: from pay_retro_assignments pra,

1054: pre.effective_date,
1055: pre.retro_component_id,
1056: pre.owner_type,
1057: pre.system_reprocess_date
1058: from pay_retro_assignments pra,
1059: pay_retro_entries pre
1060: where pra.assignment_id = p_assignment_id
1061: and pra.retro_assignment_action_id is null
1062: and pra.retro_assignment_id = pre.retro_assignment_id;

Line 1068: from pay_retro_assignments

1064: cursor get_ret_asg (p_asg_act_id in number)
1065: is
1066: select retro_assignment_id,
1067: assignment_id
1068: from pay_retro_assignments
1069: where retro_assignment_action_id = p_asg_act_id;
1070: --
1071: l_ret_asg_id pay_retro_assignments.retro_assignment_id%type;
1072: l_asg_id pay_retro_assignments.assignment_id%type;

Line 1071: l_ret_asg_id pay_retro_assignments.retro_assignment_id%type;

1067: assignment_id
1068: from pay_retro_assignments
1069: where retro_assignment_action_id = p_asg_act_id;
1070: --
1071: l_ret_asg_id pay_retro_assignments.retro_assignment_id%type;
1072: l_asg_id pay_retro_assignments.assignment_id%type;
1073: --
1074: begin
1075: --

Line 1072: l_asg_id pay_retro_assignments.assignment_id%type;

1068: from pay_retro_assignments
1069: where retro_assignment_action_id = p_asg_act_id;
1070: --
1071: l_ret_asg_id pay_retro_assignments.retro_assignment_id%type;
1072: l_asg_id pay_retro_assignments.assignment_id%type;
1073: --
1074: begin
1075: --
1076: for retasgrec in get_ret_asg(p_asg_act_id) loop

Line 1098: delete from pay_retro_assignments

1094: --
1095: end loop;
1096: --
1097: -- Remove the row that has now been replicated/merged
1098: delete from pay_retro_assignments
1099: where assignment_id = retasgrec.assignment_id
1100: and retro_assignment_action_id is null;
1101: --
1102: -- Also need to upd our rolled back RA, (done in calling pyrolbak.pkb)

Line 1203: update pay_retro_assignments

1199: actrec.process_group_id,
1200: 'POG'
1201: from dual;
1202: --
1203: update pay_retro_assignments
1204: set retro_assignment_action_id = actrec.assignment_action_id
1205: where assignment_id = asgrec.source_id
1206: and retro_assignment_action_id is null;
1207: --

Line 1430: from pay_retro_assignments

1426: begin
1427: --
1428: select retro_assignment_id
1429: into l_ret_asg
1430: from pay_retro_assignments
1431: where retro_assignment_action_id = p_assignment_action
1432: and rownum = 1;
1433: --
1434: return l_ret_asg;

Line 2044: from pay_retro_assignments

2040: -- Get the reprocess_date of the assignment for this retropay run.
2041:
2042: begin
2043: select reprocess_date into l_min_retro_asg_date
2044: from pay_retro_assignments
2045: where assignment_id =p_assignment_id
2046: and retro_assignment_action_id = p_assact_id;
2047:
2048: exception