APPS.PSP_PREGEN dependencies on PSP_ELEMENT_TYPES

Line 1343: --This procedure is to validate Element types with psp element types

1339: close check_source_csr;
1340: return;
1341: End Validate_Payroll_Source_Code;
1342: ----------------------------------VALIDATE_ELEMENT_TYPE_ID-----------------------------------
1343: --This procedure is to validate Element types with psp element types
1344: --
1345: Procedure Validate_Element_Type_ID(X_Element_Type_ID IN Number,
1346: X_Payroll_Period_ID IN Number,
1347: -- Introduced BG/SOB parameters for bug fix 3098050

Line 1354: FROM psp_element_types a,

1350: X_return_status OUT NOCOPY varchar2,
1351: X_return_code OUT NOCOPY varchar2) IS
1352: CURSOR check_element_csr IS
1353: SELECT a.element_type_id
1354: FROM psp_element_types a,
1355: per_time_periods c
1356: WHERE a.element_type_id = x_Element_Type_ID and
1357: c.time_period_id = x_payroll_period_id
1358: -- and ((c.start_date between a.start_date_active and a.end_date_active)