[Home] [Help]
130: RETURN LONG IS
131:
132: CURSOR c_tax_unit(cp_assignment_action_id NUMBER) IS
133: select tax_unit_id, payroll_action_id
134: from pay_assignment_actions
135: where assignment_action_id = cp_assignment_action_id;
136:
137: CURSOR c_action_type(cp_payroll_action_id NUMBER) IS
138: select action_type
377: ,'''' || bg.currency_code || '''' currency_code
378: ,action_type
379: ,fc.name currency_name
380: from pay_payroll_actions pa
381: , pay_assignment_actions aa
382: , per_business_groups bg
383: , fnd_currencies_vl fc
384: where aa.assignment_action_id = p_assignment_action_id
385: and aa.payroll_action_id = pa.payroll_action_id
388: and rownum = 1;
389:
390: cursor getActions is
391: select assignment_action_id
392: from pay_assignment_actions
393: where level =
394: (select max(level)
395: from pay_assignment_actions
396: connect by source_action_id = prior assignment_action_id
391: select assignment_action_id
392: from pay_assignment_actions
393: where level =
394: (select max(level)
395: from pay_assignment_actions
396: connect by source_action_id = prior assignment_action_id
397: start with assignment_action_id = p_assignment_action_id)
398: connect by source_action_id = prior assignment_action_id
399: start with assignment_action_id = p_assignment_action_id;
403: cursor lockedActions is
404: select locked_action_id,
405: action_sequence
406: from pay_action_interlocks,
407: pay_assignment_actions paa
408: where locking_action_id = p_assignment_action_id
409: and locked_action_id = assignment_action_id
410: and exists ( select 1 from pay_run_types_f prt
411: where prt.legislation_code = 'MX'
430: -- Prepay change
431: select action_type
432: into l_action_type
433: from pay_payroll_actions pa
434: ,pay_assignment_actions aa
435: where aa.assignment_action_id = p_assignment_action_id
436: and aa.payroll_action_id = pa.payroll_action_id;
437:
438: /* exception