DBA Data[Home] [Help]

APPS.PAY_ZA_EFT_RECONCILIATION dependencies on PAY_ZA_ACB_USER_GEN_NOS

Line 161: FROM PAY_ZA_ACB_USER_GEN_NOS

157: CLOSE inst_code_and_type;
158:
159: IF l_acb_user_type = 'S' THEN
160: SELECT GEN_NUMBER INTO l_gen_number
161: FROM PAY_ZA_ACB_USER_GEN_NOS
162: WHERE PAYROLL_ACTION_ID = p_payroll_action_id
163: AND USER_CODE = l_inst_code;
164: else
165: SELECT GEN_NUMBER INTO l_gen_number

Line 166: FROM PAY_ZA_ACB_USER_GEN_NOS

162: WHERE PAYROLL_ACTION_ID = p_payroll_action_id
163: AND USER_CODE = l_inst_code;
164: else
165: SELECT GEN_NUMBER INTO l_gen_number
166: FROM PAY_ZA_ACB_USER_GEN_NOS
167: WHERE PAYROLL_ACTION_ID = p_payroll_action_id
168: AND USER_CODE = l_acb_code;
169: END IF;
170: