127: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
128: ,p_date_earned DATE ) is
129: select pact.ASSIGNMENT_ACTION_ID
130: from pay_assignment_actions pact
131: ,pay_run_types_f prt
132: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
133: and pact.TAX_UNIT_ID = p_tax_unit_id
134: and prt.LEGISLATION_CODE = 'NO'
135: and prt.RUN_TYPE_NAME = 'Employer Contributions'
145: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
146: ,p_date_earned DATE ) is
147: select count(*)
148: from pay_assignment_actions pact
149: ,pay_run_types_f prt
150: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
151: and pact.TAX_UNIT_ID = p_tax_unit_id
152: and prt.LEGISLATION_CODE = 'NO'
153: and prt.RUN_TYPE_NAME = 'Employer Contributions'