DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PSP_PAYROLL_SOURCES

Line 1304: -- This procedure is to validate Source code with Psp_payroll_sources

1300: close check_period_csr;
1301: return;
1302: End Validate_Payroll_Period_ID;
1303: ----------------------------------VALIDATE_PAYROLL_SOURCE_ID-----------------------------------
1304: -- This procedure is to validate Source code with Psp_payroll_sources
1305: --
1306: Procedure Validate_Payroll_Source_Code(x_Payroll_Source_Code IN varchar2,
1307: X_return_status OUT NOCOPY varchar2,
1308: X_return_code OUT NOCOPY varchar2) IS

Line 1311: FROM PSP_PAYROLL_SOURCES

1307: X_return_status OUT NOCOPY varchar2,
1308: X_return_code OUT NOCOPY varchar2) IS
1309: CURSOR check_source_csr IS
1310: SELECT source_code
1311: FROM PSP_PAYROLL_SOURCES
1312: WHERE source_code = x_Payroll_Source_Code and
1313: source_type = 'P';
1314: l_lookup_code varchar2(30);
1315: Begin