[Home] [Help]
81: p_start_person_id in per_all_people_f.person_id%type,
82: p_end_person_id in per_all_people_f.person_id%type,
83: p_chunk in number )
84: is
85: v_next_action_id pay_assignment_actions.assignment_action_id%type;
86: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
87: v_assignment_id per_all_assignments_f.assignment_id%type;
88: --
89: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
91: from pay_payroll_actions
92: where payroll_action_id = c_payroll_Action_id;
93: --
94: cursor next_action_id is
95: select pay_assignment_actions_s.nextval
96: from dual;
97: --
98: cursor process_assignments ( c_setup_action_id in pay_payroll_actions.payroll_action_id%type ) is
99: select distinct pai.assignment_id
208: p_start_person_id in per_all_people_f.person_id%type,
209: p_end_person_id in per_all_people_f.person_id%type,
210: p_chunk in number )
211: is
212: v_next_action_id pay_assignment_actions.assignment_action_id%type;
213: v_person_id per_all_people_f.person_id%type;
214: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
215: v_business_group_id number;
216: v_basis_start date;
234: ----------------------------------------------------------------------------
235: -- Cursor Next Assignment Action
236: ----------------------------------------------------------------------------
237: cursor next_action_id is
238: select pay_assignment_actions_s.nextval
239: from dual;
240: ----------------------------------------------------------------------------
241: -- Cursor Process_assignments
242: -- Bug: 3404526 - Added max(assignment_id) to pick the latest assignment in case of Normal rehire.
264: decode(hr_assignment_set.ASSIGNMENT_IN_SET(c_assignment_set_id,paf.assignment_id),'Y','Y','N')) = 'Y'
265: and exists
266: ( select null
267: from pay_payroll_actions ppa,
268: pay_assignment_actions paa
269: where ppa.payroll_action_id = paa.payroll_action_id
270: and paa.assignment_id = paf.assignment_id
271: and paa.tax_unit_id = c_legal_entity_id
272: and ppa.effective_date between c_basis_start and c_basis_end
372: -- Bug: 3118540 - This function is called from the report PYSG8SAD.rdf - 'IR8S Ad Hoc Printed Report'
373: -----------------------------------------------------------------------------------------------------
374: function get_archive_value
375: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
376: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type) return varchar2
377: is
378: cursor csr_get_value( p_user_entity_name varchar2,
379: p_assignment_action_id number ) is
380: select fai.value
419: -- to archive the data in groups because depending on the data,
420: -- different parameters are required.
421: ------------------------------------------------------------------------
422: procedure archive_code
423: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
424: p_effective_date in date )
425: is
426: v_person_id per_all_people_f.person_id%type;
427: v_assignment_id per_all_assignments_f.assignment_id%type;
434: -- Bug 2920732 - Modified the cursor to use secured views per_people_f, per_assignments_f
435: -- Bug 3260855 - Modified the cusor to fetch only person_id, asg_id instead of
436: -- legislative parameters as global values can be used, which are initialized in Init_code.
437: ------------------------------------------------------------------------
438: cursor get_details( c_assignment_action_id pay_assignment_actions.assignment_action_id%type ) is
439: select pap.person_id,
440: nvl(pap.national_identifier,pap.per_information12),
441: pac.assignment_id
442: from pay_assignment_actions pac,
438: cursor get_details( c_assignment_action_id pay_assignment_actions.assignment_action_id%type ) is
439: select pap.person_id,
440: nvl(pap.national_identifier,pap.per_information12),
441: pac.assignment_id
442: from pay_assignment_actions pac,
443: per_assignments_f paa,
444: per_people_f pap
445: where pac.assignment_action_id = c_assignment_action_id
446: and paa.assignment_id = pac.assignment_id
585: -- Do not include Obsoleted balances
586: ---------------------------------------------------------------------------------------
587: procedure a8a_balances_value
588: ( p_person_id in per_people_f.person_id%type,
589: p_assct_id in pay_assignment_actions.assignment_action_id%type,
590: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
591: p_person_counter in number )
592: is
593: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
586: ---------------------------------------------------------------------------------------
587: procedure a8a_balances_value
588: ( p_person_id in per_people_f.person_id%type,
589: p_assct_id in pay_assignment_actions.assignment_action_id%type,
590: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
591: p_person_counter in number )
592: is
593: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
594: l_context_tab pay_balance_pkg.t_context_tab;
1057: -- Month Balances: Specific balances required for IR8S as this breaks down
1058: -- earnings by month.
1059: ---------------------------------------------------------------------------
1060: procedure archive_balances
1061: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1062: p_person_id in per_all_people_f.person_id%type,
1063: p_business_group_id in hr_organization_units.business_group_id%type,
1064: p_tax_unit_id in ff_archive_item_contexts.context%type,
1065: p_basis_year in varchar2 )
1063: p_business_group_id in hr_organization_units.business_group_id%type,
1064: p_tax_unit_id in ff_archive_item_contexts.context%type,
1065: p_basis_year in varchar2 )
1066: is
1067: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;
1068: v_date_earned ff_archive_item_contexts.context%type;
1069: v_balance_value ff_archive_items.value%type;
1070: v_archive_item_id ff_archive_items.archive_item_id%type;
1071: v_object_version_number ff_archive_items.object_version_number%type;
1128: ---------------------------------------------------------------------------------------------------
1129: cursor month_year_action_sequence
1130: ( c_person_id per_all_people_f.person_id%type,
1131: c_business_group_id hr_organization_units.business_group_id%type,
1132: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
1133: c_basis_year varchar2 )
1134: is
1135: select /*+ ORDERED USE_NL(pacmax) */
1136: max(pacmax.action_sequence) act_seq,
1135: select /*+ ORDERED USE_NL(pacmax) */
1136: max(pacmax.action_sequence) act_seq,
1137: to_char(ppamax.effective_date,'MM')
1138: from per_assignments_f paamax,
1139: pay_assignment_actions pacmax,
1140: pay_payroll_actions ppamax
1141: where ppamax.business_group_id = c_business_group_id
1142: and pacmax.tax_unit_id = c_legal_entity_id
1143: and paamax.person_id = c_person_id
1153: ---------------------------------------------------------------------------------------------------
1154: cursor month_year_action
1155: ( c_person_id per_all_people_f.person_id%type,
1156: c_business_group_id hr_organization_units.business_group_id%type,
1157: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
1158: c_basis_year varchar2,
1159: c_action_sequence pay_assignment_actions.action_sequence%type )
1160: is
1161: select /*+ ORDERED USE_NL(pac) */
1155: ( c_person_id per_all_people_f.person_id%type,
1156: c_business_group_id hr_organization_units.business_group_id%type,
1157: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
1158: c_basis_year varchar2,
1159: c_action_sequence pay_assignment_actions.action_sequence%type )
1160: is
1161: select /*+ ORDERED USE_NL(pac) */
1162: pac.assignment_action_id assact_id,
1163: decode(ppa.action_type,'V',fnd_date.date_to_canonical(ppa.effective_date),fnd_date.date_to_canonical(ppa.date_earned)) date_earned,
1162: pac.assignment_action_id assact_id,
1163: decode(ppa.action_type,'V',fnd_date.date_to_canonical(ppa.effective_date),fnd_date.date_to_canonical(ppa.date_earned)) date_earned,
1164: pac.tax_unit_id tax_uid
1165: from per_assignments_f paa,
1166: pay_assignment_actions pac,
1167: pay_payroll_actions ppa
1168: where ppa.business_group_id = c_business_group_id
1169: and pac.tax_unit_id = c_legal_entity_id
1170: and paa.person_id = c_person_id
1753: procedure archive_balance_dates
1754: ( p_person_id in per_all_people_f.person_id%TYPE,
1755: p_basis_year in varchar2,
1756: p_business_group_id in hr_organization_units.business_group_id%type,
1757: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1758: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,
1759: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1760: is
1761: --
1754: ( p_person_id in per_all_people_f.person_id%TYPE,
1755: p_basis_year in varchar2,
1756: p_business_group_id in hr_organization_units.business_group_id%type,
1757: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1758: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,
1759: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1760: is
1761: --
1762: v_date_from ff_archive_items.value%type;
1755: p_basis_year in varchar2,
1756: p_business_group_id in hr_organization_units.business_group_id%type,
1757: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1758: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,
1759: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1760: is
1761: --
1762: v_date_from ff_archive_items.value%type;
1763: v_date_to ff_archive_items.value%type;
1773: v_moa_413_date ff_archive_items.value%type;
1774: l_terminated varchar2(1);
1775: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1776: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1777: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;
1778: l_term_max_assact_id pay_assignment_actions.assignment_action_id%TYPE;
1779: l_person_id per_all_people_f.person_id%type;
1780: v_person_id per_all_people_f.person_id%type;
1781:
1774: l_terminated varchar2(1);
1775: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1776: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1777: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;
1778: l_term_max_assact_id pay_assignment_actions.assignment_action_id%TYPE;
1779: l_person_id per_all_people_f.person_id%type;
1780: v_person_id per_all_people_f.person_id%type;
1781:
1782: ---------------------------------------------------------------------------
1807: -- Bug# 2920732 - Modified the cursor to use secured view per_assignments_f
1808: ---------------------------------------------------------------------------
1809: cursor get_max_assactid( c_prev_ass_id per_all_assignments_f.assignment_id%TYPE ,
1810: c_basis_year varchar2,
1811: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
1812: c_business_group_id hr_organization_units.business_group_id%type )
1813: is
1814: select assact1.assignment_action_id
1815: from pay_assignment_actions assact1,
1811: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
1812: c_business_group_id hr_organization_units.business_group_id%type )
1813: is
1814: select assact1.assignment_action_id
1815: from pay_assignment_actions assact1,
1816: pay_payroll_actions pact1,
1817: per_assignments_f paaf1
1818: where assact1.tax_unit_id = c_tax_unit_id
1819: and paaf1.assignment_id = c_prev_ass_id
1822: and paaf1.business_group_id = c_business_group_id
1823: and pact1.action_status = 'C'
1824: and assact1.action_sequence =
1825: ( select max(assact.action_sequence)
1826: from pay_assignment_actions assact,
1827: pay_payroll_actions pact,
1828: per_assignments_f paaf
1829: where paaf.assignment_id = paaf1.assignment_id
1830: and paaf.assignment_id = assact.assignment_id
1839: -----------------------------------------------------------------------------------------
1840: ---Bug#3956870 Function uses run balances to fetch balance details if they are valid
1841: -------------------------------------------------------------------------------------------
1842: --
1843: procedure get_balance_dates ( p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
1844: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1845: p_balance_name in pay_balance_types.balance_name%type,
1846: p_business_group_id in hr_organization_units.business_group_id%type,
1847: p_date_from out nocopy ff_archive_items.value%type,
1840: ---Bug#3956870 Function uses run balances to fetch balance details if they are valid
1841: -------------------------------------------------------------------------------------------
1842: --
1843: procedure get_balance_dates ( p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
1844: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1845: p_balance_name in pay_balance_types.balance_name%type,
1846: p_business_group_id in hr_organization_units.business_group_id%type,
1847: p_date_from out nocopy ff_archive_items.value%type,
1848: p_date_to out nocopy ff_archive_items.value%type,
1860: from pay_run_result_values target,
1861: pay_balance_feeds_f feed,
1862: pay_balance_types pbt,
1863: pay_run_results rr,
1864: pay_assignment_actions assact,
1865: pay_assignment_actions bal_assact,
1866: pay_payroll_actions pact,
1867: pay_payroll_actions bact,
1868: per_assignments_f ass
1861: pay_balance_feeds_f feed,
1862: pay_balance_types pbt,
1863: pay_run_results rr,
1864: pay_assignment_actions assact,
1865: pay_assignment_actions bal_assact,
1866: pay_payroll_actions pact,
1867: pay_payroll_actions bact,
1868: per_assignments_f ass
1869: where bal_assact.assignment_action_id = p_asg_action_id
1894: select fnd_date.date_to_canonical(min(prb.effective_date)) date_from,
1895: fnd_date.date_to_canonical(max(prb.effective_date)) date_to,
1896: sum(decode(ppa.action_type,'V',-1,1)) no_of_times
1897: from pay_run_balances prb,
1898: pay_assignment_actions ASSACT,
1899: pay_payroll_actions PACT,
1900: per_assignments_f ass,
1901: pay_payroll_actions ppa,
1902: pay_assignment_actions paa
1898: pay_assignment_actions ASSACT,
1899: pay_payroll_actions PACT,
1900: per_assignments_f ass,
1901: pay_payroll_actions ppa,
1902: pay_assignment_actions paa
1903: where prb.defined_balance_id = c_def_balance_id
1904: and assact.assignment_action_id = p_asg_action_id
1905: and assact.payroll_action_id = pact.payroll_action_id
1906: and prb.assignment_action_id = paa.assignment_action_id
2482: ---------------------------------------------------------------------------
2483: -- Copies the Org Developer DF route code to get Legal Entity information.
2484: ---------------------------------------------------------------------------
2485: procedure archive_org_info
2486: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2487: p_business_group_id in hr_organization_units.business_group_id%type,
2488: p_legal_entity_id in hr_organization_units.organization_id%type,
2489: p_person_id in per_all_people_f.person_id%type,
2490: p_basis_start in date,
2719: --------------------------------------------------------------------------
2720: -- Bug 5435088, Added for payroll date
2721: --------------------------------------------------------------------------
2722: procedure archive_payroll_date
2723: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2724: p_business_group_id in hr_organization_units.business_group_id%type,
2725: p_legal_entity_id in hr_organization_units.organization_id%type,
2726: p_person_id in per_all_people_f.person_id%type,
2727: p_basis_year in varchar2) is
2734: c_basis_year varchar2)
2735: is
2736: select fnd_date.date_to_canonical(max(ppamax.effective_date))
2737: from per_assignments_f paamax,
2738: pay_assignment_actions pacmax,
2739: pay_payroll_actions ppamax
2740: where ppamax.business_group_id = c_business_group_id
2741: and pacmax.tax_unit_id = c_legal_entity_id
2742: and paamax.person_id = c_person_id
2768: ---------------------------------------------------------------------------
2769: -- Copies the standard Person information route code.
2770: ---------------------------------------------------------------------------
2771: procedure archive_person_details
2772: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2773: p_person_id in per_all_people_f.person_id%type,
2774: p_basis_start in date,
2775: p_basis_end in date )
2776: is
2828: ---------------------------------------------------------------------------
2829: -- Copies the standard Person Address information route code.
2830: ---------------------------------------------------------------------------
2831: procedure archive_person_addresses
2832: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2833: p_person_id in per_all_people_f.person_id%type,
2834: p_basis_start in date,
2835: p_basis_end in date )
2836: is
2913: -- Copies the standard Person Company Quarters address
2914: -- Bug 4688761, to separate from the above procedure
2915: ---------------------------------------------------------------------------
2916: procedure archive_person_cq_addresses
2917: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2918: p_person_id in per_all_people_f.person_id%type,
2919: p_basis_start in date,
2920: p_basis_end in date )
2921: is
2978: ---------------------------------------------------------------------------
2979: -- Copies the standard Employee information route code.
2980: ---------------------------------------------------------------------------
2981: procedure archive_emp_details
2982: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2983: p_person_id in per_all_people_f.person_id%type,
2984: p_basis_start in date,
2985: p_basis_end in date) is
2986:
3041: ---------------------------------------------------------------------------
3042: -- Copies the standard Person Developer DF route code.
3043: ---------------------------------------------------------------------------
3044: procedure archive_people_flex
3045: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3046: p_person_id in per_all_people_f.person_id%type,
3047: p_basis_start in date,
3048: p_basis_end in date)
3049: is
3143: ---------------------------------------------------------------------------
3144: -- Copies the standard Extra Person Information DF route code.
3145: ---------------------------------------------------------------------------
3146: procedure archive_person_eits
3147: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3148: p_person_id in per_all_people_f.person_id%type,
3149: p_basis_start in date,
3150: p_basis_end in date )
3151: is
3252: -- Copies the standard Extra Assignment Information DF route code. - Bug 2373475
3253: -- Added p_assignment_id as parameter
3254: ---------------------------------------------------------------------------
3255: procedure archive_assignment_eits
3256: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3257: p_person_id in per_all_people_f.person_id%type,
3258: p_assignment_id in per_all_assignments_f.assignment_id%type,
3259: p_legal_entity_id in hr_organization_units.organization_id%type,
3260: p_basis_start in date,
3320: -- archive it to DTM161 if it is not blank, otherwise archive the global
3321: -- value g_moa_369_date
3322: ---------------------------------------------------------------------------
3323: procedure archive_ass_bonus_date_eits
3324: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3325: p_person_id in per_all_people_f.person_id%type,
3326: p_assignment_id in per_all_assignments_f.assignment_id%type,
3327: p_legal_entity_id in hr_organization_units.organization_id%type,
3328: p_basis_start in date,
3385: -- Bug 5868910 - Added effective_start_date sub-query for the date tracked
3386: -- payment method
3387: ---------------------------------------------------------------------------
3388: procedure archive_ass_payment_method
3389: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3390: p_person_id in per_all_people_f.person_id%type,
3391: p_assignment_id in per_all_assignments_f.assignment_id%type,
3392: p_legal_entity_id in hr_organization_units.organization_id%type,
3393: p_basis_start in date,
3462: -- for Job Designation
3463: -- Bug 4890964, added p_assignment_id as parameter
3464: ---------------------------------------------------------------------------
3465: procedure archive_job_designation
3466: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3467: p_person_id in per_all_people_f.person_id%type,
3468: p_assignment_id in per_all_assignments_f.assignment_id%type,
3469: p_legal_entity_id in hr_organization_units.organization_id%type,
3470: p_basis_start in date,
3767: -- having the CPF Overseas Post Obligatory Indicator entered for an
3768: -- assignment whose duration is within Basis Year.
3769: ---------------------------------------------------------------------------
3770: procedure archive_os_assignment
3771: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3772: p_person_id in per_all_people_f.person_id%type,
3773: p_legal_entity_id in hr_organization_units.organization_id%type,
3774: p_basis_start in date,
3775: p_basis_end in date )
3835: -- Selects information for Shares information, which is entered via assignment
3836: -- extra information screen, bug 2475287
3837: ---------------------------------------------------------------------------
3838: procedure archive_shares_details
3839: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3840: p_person_id in per_all_people_f.person_id%type,
3841: p_tax_unit_id in ff_archive_item_contexts.context%type,
3842: p_basis_start in date,
3843: p_basis_end in date )
3972: -- Selects information for IR8S C claimed/to be claimed details information,
3973: -- which is entered via assignment extra information screen, bug 3027801
3974: ---------------------------------------------------------------------------
3975: procedure archive_ir8s_c_details
3976: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3977: p_person_id in per_all_people_f.person_id%type,
3978: p_tax_unit_id in ff_archive_item_contexts.context%type,
3979: p_business_group_id in per_assignments_f.business_group_id%type,
3980: p_basis_start in date,
4098: end archive_ir8s_c_details;
4099:
4100:
4101: procedure archive_ir8s_c_detail_moas
4102: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4103: p_1_person_id in per_all_people_f.person_id%type,
4104: p_person_id in per_all_people_f.person_id%type,
4105: p_tax_unit_id in ff_archive_item_contexts.context%type,
4106: p_business_group_id in per_assignments_f.business_group_id%type,
4201: -- Calls the archive utility to actually perform the archive of the item.
4202: ---------------------------------------------------------------------------
4203: procedure archive_item
4204: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4205: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4206: p_archive_value in ff_archive_items.value%type )
4207: is
4208: --
4209: v_user_entity_id ff_user_entities.user_entity_id%type;
4252: -- one another context
4253: -----------------------------------------------------------------------------
4254: procedure archive_item_2
4255: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4256: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4257: p_archive_value in ff_archive_items.value%type,
4258: p_context_value2 in ff_archive_item_contexts.context%type )
4259: is
4260: --
4306: -- one another context
4307: -----------------------------------------------------------------------------
4308: procedure archive_item_3
4309: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4310: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4311: p_archive_value in ff_archive_items.value%type,
4312: p_context_value2 in ff_archive_item_contexts.context%type,
4313: p_context_value3 in ff_archive_item_contexts.context%type )
4314: is
4497: is
4498: v_dummy varchar2(1);
4499: cursor pri_latest
4500: ( c_person_id per_all_people_f.person_id%type,
4501: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
4502: c_basis_start date,
4503: c_basis_end date )
4504: is
4505: select 'X'
4560: is
4561: v_assignment_id number(10);
4562: cursor pri_latest_LE
4563: ( c_person_id per_all_people_f.person_id%type,
4564: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
4565: c_basis_start date,
4566: c_basis_end date )
4567: is
4568: select paf.assignment_id
4629: is
4630: v_assignment_id number(10);
4631: cursor id_latest_LE
4632: ( c_person_id per_all_people_f.person_id%type,
4633: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
4634: c_basis_start date,
4635: c_basis_end date )
4636: is
4637: select max(paf.assignment_id)