APPS.PAY_RETRO_PKG dependencies on PAY_RETRO_ASSIGNMENTS

Line 626: from pay_retro_assignments pra,

622: and pee.assignment_id = paa_ret.assignment_id);
623: --
624: select min(pra.reprocess_date)
625: into l_reprocess_start_date
626: from pay_retro_assignments pra,
627: pay_payroll_actions ppa,
628: pay_assignment_actions paa_ret,
629: pay_assignment_actions paa_mret
630: where ppa.effective_date between p_start_date

Line 1027: from pay_retro_assignments pra,

1023: pre.effective_date,
1024: pre.retro_component_id,
1025: pre.owner_type,
1026: pre.system_reprocess_date
1027: from pay_retro_assignments pra,
1028: pay_retro_entries pre
1029: where pra.assignment_id = p_assignment_id
1030: and pra.retro_assignment_action_id is null
1031: and pra.retro_assignment_id = pre.retro_assignment_id;

Line 1037: from pay_retro_assignments

1033: cursor get_ret_asg (p_asg_act_id in number)
1034: is
1035: select retro_assignment_id,
1036: assignment_id
1037: from pay_retro_assignments
1038: where retro_assignment_action_id = p_asg_act_id;
1039: --
1040: l_ret_asg_id pay_retro_assignments.retro_assignment_id%type;
1041: l_asg_id pay_retro_assignments.assignment_id%type;

Line 1040: l_ret_asg_id pay_retro_assignments.retro_assignment_id%type;

1036: assignment_id
1037: from pay_retro_assignments
1038: where retro_assignment_action_id = p_asg_act_id;
1039: --
1040: l_ret_asg_id pay_retro_assignments.retro_assignment_id%type;
1041: l_asg_id pay_retro_assignments.assignment_id%type;
1042: --
1043: begin
1044: --

Line 1041: l_asg_id pay_retro_assignments.assignment_id%type;

1037: from pay_retro_assignments
1038: where retro_assignment_action_id = p_asg_act_id;
1039: --
1040: l_ret_asg_id pay_retro_assignments.retro_assignment_id%type;
1041: l_asg_id pay_retro_assignments.assignment_id%type;
1042: --
1043: begin
1044: --
1045: for retasgrec in get_ret_asg(p_asg_act_id) loop

Line 1067: delete from pay_retro_assignments

1063: --
1064: end loop;
1065: --
1066: -- Remove the row that has now been replicated/merged
1067: delete from pay_retro_assignments
1068: where assignment_id = retasgrec.assignment_id
1069: and retro_assignment_action_id is null;
1070: --
1071: -- Also need to upd our rolled back RA, (done in calling pyrolbak.pkb)

Line 1172: update pay_retro_assignments

1168: actrec.process_group_id,
1169: 'POG'
1170: from dual;
1171: --
1172: update pay_retro_assignments
1173: set retro_assignment_action_id = actrec.assignment_action_id
1174: where assignment_id = asgrec.source_id
1175: and retro_assignment_action_id is null;
1176: --

Line 1399: from pay_retro_assignments

1395: begin
1396: --
1397: select retro_assignment_id
1398: into l_ret_asg
1399: from pay_retro_assignments
1400: where retro_assignment_action_id = p_assignment_action
1401: and rownum = 1;
1402: --
1403: return l_ret_asg;

Line 1894: from pay_retro_assignments

1890: -- Get the reprocess_date of the assignment for this retropay run.
1891:
1892: begin
1893: select reprocess_date into l_min_retro_asg_date
1894: from pay_retro_assignments
1895: where assignment_id =p_assignment_id
1896: and retro_assignment_action_id = p_assact_id;
1897:
1898: exception