APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 374: pay_assignment_actions act,

370: prepaid_action_id, appa.effective_date, appa.payroll_action_id,
371: appa2.payroll_action_id payactid, hsck.segment2 local_unit_id
372: from pay_payroll_actions appa,
373: pay_payroll_actions appa2,
374: pay_assignment_actions act,
375: pay_assignment_actions act1,
376: pay_action_interlocks pai,
377: per_all_assignments_f paaf,
378: hr_soft_coding_keyflex hsck,

Line 375: pay_assignment_actions act1,

371: appa2.payroll_action_id payactid, hsck.segment2 local_unit_id
372: from pay_payroll_actions appa,
373: pay_payroll_actions appa2,
374: pay_assignment_actions act,
375: pay_assignment_actions act1,
376: pay_action_interlocks pai,
377: per_all_assignments_f paaf,
378: hr_soft_coding_keyflex hsck,
379: hr_organization_information hoi,

Line 762: select pay_assignment_actions_s.nextval

758: if benefit_archive_details.count > 0 then
759: for k in benefit_archive_details.first .. benefit_archive_details.last
760: loop
761: if benefit_archive_details (k).benefit_name <> 'Car Benefit' then
762: select pay_assignment_actions_s.nextval
763: into l_actid
764: from dual;
765:
766: hr_nonrun_asact.insact (

Line 808: select pay_assignment_actions_s.nextval

804: benefit_archive_details (k).pay_current_end_date,
805: null
806: )
807: loop
808: select pay_assignment_actions_s.nextval
809: into l_actid
810: from dual;
811:
812: hr_nonrun_asact.insact (

Line 905: select pay_assignment_actions_s.nextval

901: loop
902: l_prepay_action_id := 0;
903:
904: if l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id then
905: select pay_assignment_actions_s.nextval
906: into l_actid
907: from dual;
908:
909: g_run_payroll_action_id := rec_prepaid_assignments.payroll_action_id;

Line 1042: from per_all_assignments_f paaf, pay_assignment_actions paa

1038: l_tax_card_type varchar2 (200);
1039:
1040: /*Cursor csr_temination_date is
1041: select paaf.effective_start_date - 1 term_dt
1042: from per_all_assignments_f paaf, pay_assignment_actions paa
1043: where paaf.assignment_id = paa.assignment_id
1044: and paa.assignment_action_id = p_arch_assignment_action_id
1045: and assignment_status_type_id = (select assignment_status_type_id
1046: from per_assignment_status_types

Line 1076: from per_all_people_f papf, per_all_assignments_f paaf, pay_assignment_actions pac

1072: p_effective_date date
1073: ) is
1074: select papf.person_id person_id, paaf.assignment_id, national_identifier, full_name, employee_number,
1075: hourly_salaried_code, paaf.primary_flag, papf.date_of_birth, paaf.job_id, position_id
1076: from per_all_people_f papf, per_all_assignments_f paaf, pay_assignment_actions pac
1077: where pac.assignment_action_id = p_arch_assignment_action_id
1078: and paaf.assignment_id = pac.assignment_id
1079: and paaf.person_id = papf.person_id
1080: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date

Line 1171: from pay_action_information pai, pay_assignment_actions paa

1167: cursor csr_person_archived (
1168: p_person_id number
1169: ) is
1170: select 'Y'
1171: from pay_action_information pai, pay_assignment_actions paa
1172: where pai.action_context_id = paa.assignment_action_id
1173: and paa.payroll_action_id = g_arch_payroll_action_id
1174: and action_information1 = 'PYFIPSTA'
1175: and action_information2 = 'PERSON DETAILS'

Line 1182: from pay_action_information pai, pay_assignment_actions paa

1178: cursor csr_payroll_archived (
1179: p_person_id number
1180: ) is
1181: select 'Y'
1182: from pay_action_information pai, pay_assignment_actions paa
1183: where pai.action_context_id = paa.assignment_action_id
1184: and paa.payroll_action_id = g_arch_payroll_action_id
1185: and action_information1 = 'PYFIPSTA'
1186: and action_information2 = 'Payroll Details'