[Home] [Help]
135: RETURN CLOB IS
136:
137: CURSOR c_tax_unit(cp_assignment_action_id NUMBER) IS
138: select tax_unit_id, payroll_action_id
139: from pay_assignment_actions
140: where assignment_action_id = cp_assignment_action_id;
141:
142: CURSOR c_action_type(cp_payroll_action_id NUMBER) IS
143: select action_type
382: ,'''' || bg.currency_code || '''' currency_code
383: ,action_type
384: ,fc.name currency_name
385: from pay_payroll_actions pa
386: , pay_assignment_actions aa
387: , per_business_groups bg
388: , fnd_currencies_vl fc
389: where aa.assignment_action_id = p_assignment_action_id
390: and aa.payroll_action_id = pa.payroll_action_id
393: and rownum = 1;
394:
395: cursor getActions is
396: select assignment_action_id
397: from pay_assignment_actions
398: where level =
399: (select max(level)
400: from pay_assignment_actions
401: connect by source_action_id = prior assignment_action_id
396: select assignment_action_id
397: from pay_assignment_actions
398: where level =
399: (select max(level)
400: from pay_assignment_actions
401: connect by source_action_id = prior assignment_action_id
402: start with assignment_action_id = p_assignment_action_id)
403: connect by source_action_id = prior assignment_action_id
404: start with assignment_action_id = p_assignment_action_id;
408: cursor lockedActions is
409: select locked_action_id,
410: action_sequence
411: from pay_action_interlocks,
412: pay_assignment_actions paa
413: where locking_action_id = p_assignment_action_id
414: and locked_action_id = assignment_action_id
415: and exists ( select 1 from pay_run_types_f prt
416: where prt.legislation_code = 'MX'
435: -- Prepay change
436: select action_type
437: into l_action_type
438: from pay_payroll_actions pa
439: ,pay_assignment_actions aa
440: where aa.assignment_action_id = p_assignment_action_id
441: and aa.payroll_action_id = pa.payroll_action_id;
442:
443: /* exception