APPS.PAY_MX_SOE_SS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 144: from pay_payroll_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
144: from pay_payroll_actions
145: where payroll_action_id = cp_payroll_action_id;
146:
147: ln_tax_unit_id number;
148: ln_pyrl_act_id number;

Line 385: from pay_payroll_actions pa

381: , aa.tax_unit_id
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

Line 406: l_action_type pay_payroll_actions.action_type%type;

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;
405:
406: l_action_type pay_payroll_actions.action_type%type;
407:
408: cursor lockedActions is
409: select locked_action_id,
410: action_sequence

Line 438: from pay_payroll_actions pa

434: --
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: