DBA Data[Home] [Help]

APPS.PAY_GET_JOB_SEGMENT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 50: from pay_payroll_actions pact

46: --
47: cursor CSR_GET_TAX_REF(pactid NUMBER) IS
48: select
49: substr(pact.legislative_parameters, instr(pact.legislative_parameters,'TAX_REF=')+8, instr(pact.legislative_parameters||' ',' ',instr(pact.legislative_parameters,'TAX_REF=')+8) - instr(pact.legislative_parameters,'TAX_REF=')-8)
50: from pay_payroll_actions pact
51: where pact.payroll_action_id = pactid;
52:
53: --
54: cursor csr_col_name(l_tax_ref VARCHAR2) is