[Home] [Help]
84: p_start_person_id in per_all_people_f.person_id%type,
85: p_end_person_id in per_all_people_f.person_id%type,
86: p_chunk in number )
87: is
88: v_next_action_id pay_assignment_actions.assignment_action_id%type;
89: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
90: v_assignment_id per_all_assignments_f.assignment_id%type;
91: --
92: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
94: from pay_payroll_actions
95: where payroll_action_id = c_payroll_Action_id;
96: --
97: cursor next_action_id is
98: select pay_assignment_actions_s.nextval
99: from dual;
100: --
101: cursor process_assignments ( c_setup_action_id in pay_payroll_actions.payroll_action_id%type ) is
102: select distinct pai.assignment_id
211: p_start_person_id in per_all_people_f.person_id%type,
212: p_end_person_id in per_all_people_f.person_id%type,
213: p_chunk in number )
214: is
215: v_next_action_id pay_assignment_actions.assignment_action_id%type;
216: v_person_id per_all_people_f.person_id%type;
217: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
218: v_business_group_id number;
219: v_basis_start date;
237: ----------------------------------------------------------------------------
238: -- Cursor Next Assignment Action
239: ----------------------------------------------------------------------------
240: cursor next_action_id is
241: select pay_assignment_actions_s.nextval
242: from dual;
243: ----------------------------------------------------------------------------
244: -- Cursor Process_assignments
245: -- Bug: 3404526 - Added max(assignment_id) to pick the latest assignment in case of Normal rehire.
267: decode(hr_assignment_set.ASSIGNMENT_IN_SET(c_assignment_set_id,paf.assignment_id),'Y','Y','N')) = 'Y'
268: and exists
269: ( select null
270: from pay_payroll_actions ppa,
271: pay_assignment_actions paa
272: where ppa.payroll_action_id = paa.payroll_action_id
273: and paa.assignment_id = paf.assignment_id
274: and paa.tax_unit_id = c_legal_entity_id
275: and ppa.effective_date between c_basis_start and c_basis_end
375: -- Bug: 3118540 - This function is called from the report PYSG8SAD.rdf - 'IR8S Ad Hoc Printed Report'
376: -----------------------------------------------------------------------------------------------------
377: function get_archive_value
378: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
379: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type) return varchar2
380: is
381: cursor csr_get_value( p_user_entity_name varchar2,
382: p_assignment_action_id number ) is
383: select fai.value
422: -- to archive the data in groups because depending on the data,
423: -- different parameters are required.
424: ------------------------------------------------------------------------
425: procedure archive_code
426: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
427: p_effective_date in date )
428: is
429: v_person_id per_all_people_f.person_id%type;
430: v_assignment_id per_all_assignments_f.assignment_id%type;
437: -- Bug 2920732 - Modified the cursor to use secured views per_people_f, per_assignments_f
438: -- Bug 3260855 - Modified the cusor to fetch only person_id, asg_id instead of
439: -- legislative parameters as global values can be used, which are initialized in Init_code.
440: ------------------------------------------------------------------------
441: cursor get_details( c_assignment_action_id pay_assignment_actions.assignment_action_id%type ) is
442: select pap.person_id,
443: nvl(pap.national_identifier,pap.per_information12),
444: pac.assignment_id
445: from pay_assignment_actions pac,
441: cursor get_details( c_assignment_action_id pay_assignment_actions.assignment_action_id%type ) is
442: select pap.person_id,
443: nvl(pap.national_identifier,pap.per_information12),
444: pac.assignment_id
445: from pay_assignment_actions pac,
446: per_assignments_f paa,
447: per_people_f pap
448: where pac.assignment_action_id = c_assignment_action_id
449: and paa.assignment_id = pac.assignment_id
592: -- Do not include Obsoleted balances
593: ---------------------------------------------------------------------------------------
594: procedure a8a_balances_value
595: ( p_person_id in per_people_f.person_id%type,
596: p_assct_id in pay_assignment_actions.assignment_action_id%type,
597: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
598: p_person_counter in number )
599: is
600: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
593: ---------------------------------------------------------------------------------------
594: procedure a8a_balances_value
595: ( p_person_id in per_people_f.person_id%type,
596: p_assct_id in pay_assignment_actions.assignment_action_id%type,
597: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
598: p_person_counter in number )
599: is
600: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
601: l_context_tab pay_balance_pkg.t_context_tab;
1068: -- Month Balances: Specific balances required for IR8S as this breaks down
1069: -- earnings by month.
1070: ---------------------------------------------------------------------------
1071: procedure archive_balances
1072: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1073: p_person_id in per_all_people_f.person_id%type,
1074: p_business_group_id in hr_organization_units.business_group_id%type,
1075: p_tax_unit_id in ff_archive_item_contexts.context%type,
1076: p_basis_year in varchar2 )
1074: p_business_group_id in hr_organization_units.business_group_id%type,
1075: p_tax_unit_id in ff_archive_item_contexts.context%type,
1076: p_basis_year in varchar2 )
1077: is
1078: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;
1079: v_date_earned ff_archive_item_contexts.context%type;
1080: v_balance_value ff_archive_items.value%type;
1081: v_archive_item_id ff_archive_items.archive_item_id%type;
1082: v_object_version_number ff_archive_items.object_version_number%type;
1139: ---------------------------------------------------------------------------------------------------
1140: cursor month_year_action_sequence
1141: ( c_person_id per_all_people_f.person_id%type,
1142: c_business_group_id hr_organization_units.business_group_id%type,
1143: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
1144: c_basis_year varchar2 )
1145: is
1146: select /*+ ORDERED USE_NL(pacmax) */
1147: max(pacmax.action_sequence) act_seq,
1146: select /*+ ORDERED USE_NL(pacmax) */
1147: max(pacmax.action_sequence) act_seq,
1148: to_char(ppamax.effective_date,'MM')
1149: from per_assignments_f paamax,
1150: pay_assignment_actions pacmax,
1151: pay_payroll_actions ppamax
1152: where ppamax.business_group_id = c_business_group_id
1153: and pacmax.tax_unit_id = c_legal_entity_id
1154: and paamax.person_id = c_person_id
1164: ---------------------------------------------------------------------------------------------------
1165: cursor month_year_action
1166: ( c_person_id per_all_people_f.person_id%type,
1167: c_business_group_id hr_organization_units.business_group_id%type,
1168: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
1169: c_basis_year varchar2,
1170: c_action_sequence pay_assignment_actions.action_sequence%type )
1171: is
1172: select /*+ ORDERED USE_NL(pac) */
1166: ( c_person_id per_all_people_f.person_id%type,
1167: c_business_group_id hr_organization_units.business_group_id%type,
1168: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
1169: c_basis_year varchar2,
1170: c_action_sequence pay_assignment_actions.action_sequence%type )
1171: is
1172: select /*+ ORDERED USE_NL(pac) */
1173: pac.assignment_action_id assact_id,
1174: decode(ppa.action_type,'V',fnd_date.date_to_canonical(ppa.effective_date),fnd_date.date_to_canonical(ppa.date_earned)) date_earned,
1173: pac.assignment_action_id assact_id,
1174: decode(ppa.action_type,'V',fnd_date.date_to_canonical(ppa.effective_date),fnd_date.date_to_canonical(ppa.date_earned)) date_earned,
1175: pac.tax_unit_id tax_uid
1176: from per_assignments_f paa,
1177: pay_assignment_actions pac,
1178: pay_payroll_actions ppa
1179: where ppa.business_group_id = c_business_group_id
1180: and pac.tax_unit_id = c_legal_entity_id
1181: and paa.person_id = c_person_id
1764: procedure archive_balance_dates
1765: ( p_person_id in per_all_people_f.person_id%TYPE,
1766: p_basis_year in varchar2,
1767: p_business_group_id in hr_organization_units.business_group_id%type,
1768: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1769: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,
1770: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1771: is
1772: --
1765: ( p_person_id in per_all_people_f.person_id%TYPE,
1766: p_basis_year in varchar2,
1767: p_business_group_id in hr_organization_units.business_group_id%type,
1768: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1769: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,
1770: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1771: is
1772: --
1773: v_date_from ff_archive_items.value%type;
1766: p_basis_year in varchar2,
1767: p_business_group_id in hr_organization_units.business_group_id%type,
1768: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1769: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,
1770: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1771: is
1772: --
1773: v_date_from ff_archive_items.value%type;
1774: v_date_to ff_archive_items.value%type;
1784: v_moa_413_date ff_archive_items.value%type;
1785: l_terminated varchar2(1);
1786: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1787: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1788: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;
1789: l_term_max_assact_id pay_assignment_actions.assignment_action_id%TYPE;
1790: l_person_id per_all_people_f.person_id%type;
1791: v_person_id per_all_people_f.person_id%type;
1792:
1785: l_terminated varchar2(1);
1786: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1787: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1788: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;
1789: l_term_max_assact_id pay_assignment_actions.assignment_action_id%TYPE;
1790: l_person_id per_all_people_f.person_id%type;
1791: v_person_id per_all_people_f.person_id%type;
1792:
1793: ---------------------------------------------------------------------------
1818: -- Bug# 2920732 - Modified the cursor to use secured view per_assignments_f
1819: ---------------------------------------------------------------------------
1820: cursor get_max_assactid( c_prev_ass_id per_all_assignments_f.assignment_id%TYPE ,
1821: c_basis_year varchar2,
1822: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
1823: c_business_group_id hr_organization_units.business_group_id%type )
1824: is
1825: select assact1.assignment_action_id
1826: from pay_assignment_actions assact1,
1822: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
1823: c_business_group_id hr_organization_units.business_group_id%type )
1824: is
1825: select assact1.assignment_action_id
1826: from pay_assignment_actions assact1,
1827: pay_payroll_actions pact1,
1828: per_assignments_f paaf1
1829: where assact1.tax_unit_id = c_tax_unit_id
1830: and paaf1.assignment_id = c_prev_ass_id
1833: and paaf1.business_group_id = c_business_group_id
1834: and pact1.action_status = 'C'
1835: and assact1.action_sequence =
1836: ( select max(assact.action_sequence)
1837: from pay_assignment_actions assact,
1838: pay_payroll_actions pact,
1839: per_assignments_f paaf
1840: where paaf.assignment_id = paaf1.assignment_id
1841: and paaf.assignment_id = assact.assignment_id
1850: -----------------------------------------------------------------------------------------
1851: ---Bug#3956870 Function uses run balances to fetch balance details if they are valid
1852: -------------------------------------------------------------------------------------------
1853: --
1854: procedure get_balance_dates ( p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
1855: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1856: p_balance_name in pay_balance_types.balance_name%type,
1857: p_business_group_id in hr_organization_units.business_group_id%type,
1858: p_date_from out nocopy ff_archive_items.value%type,
1851: ---Bug#3956870 Function uses run balances to fetch balance details if they are valid
1852: -------------------------------------------------------------------------------------------
1853: --
1854: procedure get_balance_dates ( p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
1855: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1856: p_balance_name in pay_balance_types.balance_name%type,
1857: p_business_group_id in hr_organization_units.business_group_id%type,
1858: p_date_from out nocopy ff_archive_items.value%type,
1859: p_date_to out nocopy ff_archive_items.value%type,
1871: from pay_run_result_values target,
1872: pay_balance_feeds_f feed,
1873: pay_balance_types pbt,
1874: pay_run_results rr,
1875: pay_assignment_actions assact,
1876: pay_assignment_actions bal_assact,
1877: pay_payroll_actions pact,
1878: pay_payroll_actions bact,
1879: per_assignments_f ass
1872: pay_balance_feeds_f feed,
1873: pay_balance_types pbt,
1874: pay_run_results rr,
1875: pay_assignment_actions assact,
1876: pay_assignment_actions bal_assact,
1877: pay_payroll_actions pact,
1878: pay_payroll_actions bact,
1879: per_assignments_f ass
1880: where bal_assact.assignment_action_id = p_asg_action_id
1905: select fnd_date.date_to_canonical(min(prb.effective_date)) date_from,
1906: fnd_date.date_to_canonical(max(prb.effective_date)) date_to,
1907: sum(decode(ppa.action_type,'V',-1,1)) no_of_times
1908: from pay_run_balances prb,
1909: pay_assignment_actions ASSACT,
1910: pay_payroll_actions PACT,
1911: per_assignments_f ass,
1912: pay_payroll_actions ppa,
1913: pay_assignment_actions paa
1909: pay_assignment_actions ASSACT,
1910: pay_payroll_actions PACT,
1911: per_assignments_f ass,
1912: pay_payroll_actions ppa,
1913: pay_assignment_actions paa
1914: where prb.defined_balance_id = c_def_balance_id
1915: and assact.assignment_action_id = p_asg_action_id
1916: and assact.payroll_action_id = pact.payroll_action_id
1917: and prb.assignment_action_id = paa.assignment_action_id
2493: ---------------------------------------------------------------------------
2494: -- Copies the Org Developer DF route code to get Legal Entity information.
2495: ---------------------------------------------------------------------------
2496: procedure archive_org_info
2497: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2498: p_business_group_id in hr_organization_units.business_group_id%type,
2499: p_legal_entity_id in hr_organization_units.organization_id%type,
2500: p_person_id in per_all_people_f.person_id%type,
2501: p_basis_start in date,
2771: --------------------------------------------------------------------------
2772: -- Bug 5435088, Added for payroll date
2773: --------------------------------------------------------------------------
2774: procedure archive_payroll_date
2775: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2776: p_business_group_id in hr_organization_units.business_group_id%type,
2777: p_legal_entity_id in hr_organization_units.organization_id%type,
2778: p_person_id in per_all_people_f.person_id%type,
2779: p_basis_year in varchar2) is
2786: c_basis_year varchar2)
2787: is
2788: select fnd_date.date_to_canonical(max(ppamax.effective_date))
2789: from per_assignments_f paamax,
2790: pay_assignment_actions pacmax,
2791: pay_payroll_actions ppamax
2792: where ppamax.business_group_id = c_business_group_id
2793: and pacmax.tax_unit_id = c_legal_entity_id
2794: and paamax.person_id = c_person_id
2820: ---------------------------------------------------------------------------
2821: -- Copies the standard Person information route code.
2822: ---------------------------------------------------------------------------
2823: procedure archive_person_details
2824: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2825: p_person_id in per_all_people_f.person_id%type,
2826: p_basis_start in date,
2827: p_basis_end in date )
2828: is
2880: ---------------------------------------------------------------------------
2881: -- Copies the standard Person Address information route code.
2882: ---------------------------------------------------------------------------
2883: procedure archive_person_addresses
2884: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2885: p_person_id in per_all_people_f.person_id%type,
2886: p_basis_start in date,
2887: p_basis_end in date )
2888: is
2968: -- Copies the standard Person Company Quarters address
2969: -- Bug 4688761, to separate from the above procedure
2970: ---------------------------------------------------------------------------
2971: procedure archive_person_cq_addresses
2972: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2973: p_person_id in per_all_people_f.person_id%type,
2974: p_basis_start in date,
2975: p_basis_end in date )
2976: is
3036: ---------------------------------------------------------------------------
3037: -- Copies the standard Employee information route code.
3038: ---------------------------------------------------------------------------
3039: procedure archive_emp_details
3040: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3041: p_person_id in per_all_people_f.person_id%type,
3042: p_legal_entity_id in hr_organization_units.organization_id%type,
3043: p_basis_start in date,
3044: p_basis_end in date) is
3170: ---------------------------------------------------------------------------
3171: -- Copies the standard Person Developer DF route code.
3172: ---------------------------------------------------------------------------
3173: procedure archive_people_flex
3174: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3175: p_person_id in per_all_people_f.person_id%type,
3176: p_basis_start in date,
3177: p_basis_end in date)
3178: is
3275: ---------------------------------------------------------------------------
3276: -- Copies the standard Extra Person Information DF route code.
3277: ---------------------------------------------------------------------------
3278: procedure archive_person_eits
3279: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3280: p_person_id in per_all_people_f.person_id%type,
3281: p_basis_start in date,
3282: p_basis_end in date )
3283: is
3381: -- Copies the standard Extra Assignment Information DF route code. - Bug 2373475
3382: -- Added p_assignment_id as parameter
3383: ---------------------------------------------------------------------------
3384: procedure archive_assignment_eits
3385: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3386: p_person_id in per_all_people_f.person_id%type,
3387: p_assignment_id in per_all_assignments_f.assignment_id%type,
3388: p_legal_entity_id in hr_organization_units.organization_id%type,
3389: p_basis_start in date,
3449: -- archive it to DTM161 if it is not blank, otherwise archive the global
3450: -- value g_moa_369_date
3451: ---------------------------------------------------------------------------
3452: procedure archive_ass_bonus_date_eits
3453: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3454: p_person_id in per_all_people_f.person_id%type,
3455: p_assignment_id in per_all_assignments_f.assignment_id%type,
3456: p_legal_entity_id in hr_organization_units.organization_id%type,
3457: p_basis_start in date,
3514: -- Bug 5868910 - Added effective_start_date sub-query for the date tracked
3515: -- payment method
3516: ---------------------------------------------------------------------------
3517: procedure archive_ass_payment_method
3518: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3519: p_person_id in per_all_people_f.person_id%type,
3520: p_assignment_id in per_all_assignments_f.assignment_id%type,
3521: p_legal_entity_id in hr_organization_units.organization_id%type,
3522: p_basis_start in date,
3592: -- for Job Designation
3593: -- Bug 4890964, added p_assignment_id as parameter
3594: ---------------------------------------------------------------------------
3595: procedure archive_job_designation
3596: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3597: p_person_id in per_all_people_f.person_id%type,
3598: p_assignment_id in per_all_assignments_f.assignment_id%type,
3599: p_legal_entity_id in hr_organization_units.organization_id%type,
3600: p_basis_start in date,
3897: -- having the CPF Overseas Post Obligatory Indicator entered for an
3898: -- assignment whose duration is within Basis Year.
3899: ---------------------------------------------------------------------------
3900: procedure archive_os_assignment
3901: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3902: p_person_id in per_all_people_f.person_id%type,
3903: p_legal_entity_id in hr_organization_units.organization_id%type,
3904: p_basis_start in date,
3905: p_basis_end in date )
3965: -- Selects information for Shares information, which is entered via assignment
3966: -- extra information screen, bug 2475287
3967: ---------------------------------------------------------------------------
3968: procedure archive_shares_details
3969: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3970: p_person_id in per_all_people_f.person_id%type,
3971: p_tax_unit_id in ff_archive_item_contexts.context%type,
3972: p_basis_start in date,
3973: p_basis_end in date )
4232: -- Selects information for IR8S C claimed/to be claimed details information,
4233: -- which is entered via assignment extra information screen, bug 3027801
4234: ---------------------------------------------------------------------------
4235: procedure archive_ir8s_c_details
4236: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4237: p_person_id in per_all_people_f.person_id%type,
4238: p_tax_unit_id in ff_archive_item_contexts.context%type,
4239: p_business_group_id in per_assignments_f.business_group_id%type,
4240: p_basis_start in date,
4358: end archive_ir8s_c_details;
4359:
4360:
4361: procedure archive_ir8s_c_detail_moas
4362: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4363: p_1_person_id in per_all_people_f.person_id%type,
4364: p_person_id in per_all_people_f.person_id%type,
4365: p_tax_unit_id in ff_archive_item_contexts.context%type,
4366: p_business_group_id in per_assignments_f.business_group_id%type,
4461: -- Calls the archive utility to actually perform the archive of the item.
4462: ---------------------------------------------------------------------------
4463: procedure archive_item
4464: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4465: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4466: p_archive_value in ff_archive_items.value%type )
4467: is
4468: --
4469: v_user_entity_id ff_user_entities.user_entity_id%type;
4512: -- one another context
4513: -----------------------------------------------------------------------------
4514: procedure archive_item_2
4515: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4517: p_archive_value in ff_archive_items.value%type,
4518: p_context_value2 in ff_archive_item_contexts.context%type )
4519: is
4520: --
4566: -- one another context
4567: -----------------------------------------------------------------------------
4568: procedure archive_item_3
4569: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4570: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4571: p_archive_value in ff_archive_items.value%type,
4572: p_context_value2 in ff_archive_item_contexts.context%type,
4573: p_context_value3 in ff_archive_item_contexts.context%type )
4574: is
4757: is
4758: v_dummy varchar2(1);
4759: cursor pri_latest
4760: ( c_person_id per_all_people_f.person_id%type,
4761: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
4762: c_basis_start date,
4763: c_basis_end date )
4764: is
4765: select 'X'
4820: is
4821: v_assignment_id number(10);
4822: cursor pri_latest_LE
4823: ( c_person_id per_all_people_f.person_id%type,
4824: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
4825: c_basis_start date,
4826: c_basis_end date )
4827: is
4828: select paf.assignment_id
4889: is
4890: v_assignment_id number(10);
4891: cursor id_latest_LE
4892: ( c_person_id per_all_people_f.person_id%type,
4893: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
4894: c_basis_start date,
4895: c_basis_end date )
4896: is
4897: select max(paf.assignment_id)