DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PSP_PAYROLL_SOURCES

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

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

Line 1308: FROM PSP_PAYROLL_SOURCES

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