149: --'ZA_Tax_On_Lump_Sums' element was processed, not for PAYROLL ACTIONS
150: --for the Payroll as at Tax Year End anymore.
151: cursor lumpsum (pay_action_id number, asg_id number) is
152: select distinct pac.context_value
153: from pay_action_contexts pac,
154: pay_assignment_actions paa,
155: pay_payroll_actions ppa,
156: ff_contexts ffc
157: where paa.assignment_id = asg_id
340:
341: CURSOR curclr (p_assignment_Action_id IN number
342: ) is
343: Select distinct context_value clearance_number
344: FROM PAY_ACTION_CONTEXTS PAC,
345: ff_contexts fcon
346: Where pac.context_id = fcon.context_id
347: AND fcon.context_name ='SOURCE_NUMBER'
348: And PAC.ASSIGNMENT_ACTION_ID in
367: -- Cursor for Directive Number Context
368: /*CURSOR curdirnum (p_assignment_action_id IN number) is
369: Select max(context_value) directive_number
370: From
371: PAY_ACTION_CONTEXTS PAC,
372: ff_contexts fcon
373: Where PAC.assignment_action_id = p_assignment_action_id
374: AND pac.context_id = fcon.context_id
375: AND fcon.context_name ='SOURCE_TEXT'; */
375: AND fcon.context_name ='SOURCE_TEXT'; */
376:
377: CURSOR curdirnum (p_ass_id IN NUMBER ,p_pact_id IN number) is
378: SELECT DISTINCT pac.context_value directive_number
379: from pay_action_contexts pac,
380: pay_assignment_actions paa,
381: pay_payroll_actions ppa,
382: ff_contexts ffc
383: where paa.assignment_id = p_ass_id