APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 197: from pay_assignment_actions paa

193: return number is
194:
195: cursor csr_latest_asg_action is
196: select paa.assignment_action_id
197: from pay_assignment_actions paa
198: where paa.assignment_id = p_assignment_id
199: and paa.rowid =
200: (
201: select substr(

Line 206: , pay_assignment_actions paa2

202: max(lpad(paa2.action_sequence, 15, 0) || paa2.rowid)
203: , -length(paa2.rowid)
204: )
205: from pay_payroll_actions ppa2
206: , pay_assignment_actions paa2
207: where paa2.assignment_id = p_assignment_id
208: and ppa2.payroll_action_id = paa2.payroll_action_id
209: and ppa2.action_type in ('R', 'Q', 'I', 'B', 'V')
210: and ppa2.effective_date >= (add_months(p_effective_date, -1)+1) /*g_canonical_start_date*/

Line 215: l_latest_asg_action pay_assignment_actions.assignment_action_id%type;

211: and ppa2.effective_date <= p_effective_date /*g_canonical_end_date*/
212: group by length(paa2.rowid)
213: );
214:
215: l_latest_asg_action pay_assignment_actions.assignment_action_id%type;
216: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
217: l_balance_value number;
218:
219:

Line 833: select pay_assignment_actions_s.nextval

829:
830: end if;
831:
832: if asg_include = TRUE then
833: select pay_assignment_actions_s.nextval
834: into lockingactid
835: from dual;
836:
837:

Line 838: -- Insert assignment into pay_assignment_actions

834: into lockingactid
835: from dual;
836:
837:
838: -- Insert assignment into pay_assignment_actions
839: hr_nonrun_asact.insact
840: (
841: lockingactid,
842: asgrec.assignment_id,

Line 1082: l_asgid pay_assignment_actions.assignment_id%type;

1078: and ffg.legislation_code = 'ZA'
1079: and p_eff_date between ffg.effective_start_date and ffg.effective_end_date;
1080:
1081:
1082: l_asgid pay_assignment_actions.assignment_id%type;
1083:
1084: l_person_id per_assignments_f.person_id%type;
1085:
1086: l_empl_stat_value varchar2(200);

Line 1123: pay_assignment_actions paa

1119: ppa.payroll_action_id
1120: into l_archive_effective_date,
1121: l_pactid --Bug 4134166
1122: from pay_payroll_actions ppa,
1123: pay_assignment_actions paa
1124: where paa.payroll_action_id = ppa.payroll_action_id
1125: and paa.assignment_action_id = p_assactid;
1126:
1127:

Line 1131: from pay_assignment_actions paa

1127:
1128: --get the assignment_id from the assignment_action_id
1129: select paa.assignment_id
1130: into l_asgid
1131: from pay_assignment_actions paa
1132: where paa.assignment_action_id = p_assactid;
1133:
1134: --get the person_id, Business Group and the
1135: --assignment's effective end date from the assignment_id