APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 198: from pay_assignment_actions paa

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

Line 207: , pay_assignment_actions paa2

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

Line 216: l_latest_asg_action pay_assignment_actions.assignment_action_id%type;

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

Line 834: select pay_assignment_actions_s.nextval

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

Line 839: -- Insert assignment into pay_assignment_actions

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

Line 1084: l_asgid pay_assignment_actions.assignment_id%type;

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

Line 1125: pay_assignment_actions paa

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

Line 1133: from pay_assignment_actions paa

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