APPS.PAY_US_NACHA_IAT_TAPE dependencies on HR_GENERAL2

Line 253: IF (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) THEN

249: g_overflow_batch := 'N';
250: hr_utility.TRACE('....IAT g_overflow_batch is : '|| g_overflow_batch);
251:
252: --Two different cursors are used based on the oracle db version for performance improvement
253: IF (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) THEN
254: OPEN csr_assignments (g_legal_company_id,
255: g_payroll_action_id,
256: g_csr_org_pay_meth_id,
257: g_rowid );

Line 472: IF (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) THEN

468: pay_mag_tape.internal_prm_values(8) := p_test_file;
469:
470:
471: --Closing the cursor which was opened based on db version
472: IF (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) THEN
473: CLOSE csr_assignments;
474: ELSE
475: CLOSE csr_assignments_no_rule;
476: END IF;

Line 999: IF (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) THEN

995:
996: write_batch_control;
997:
998: ELSIF (csr_assignments%ISOPEN OR csr_assignments_no_rule%ISOPEN) THEN
999: IF (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) THEN
1000:
1001: FETCH csr_assignments INTO g_assignment_id, g_assignment_action_id,
1002: v_amount, g_personal_payment_method_id,
1003: v_prepayment_id, g_rowid;