APPS.PSP_PREGEN dependencies on PSP_ELEMENT_TYPES

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

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

Line 1357: FROM psp_element_types a,

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