DBA Data[Home] [Help]

APPS.SSP_ERN_BUS dependencies on PER_TIME_PERIOD_TYPES

Line 454: per_time_period_types PERIOD_TYPE

450: --
451: select period_type.number_per_fiscal_year fiscal_year
452: from pay_all_payrolls_f PAYROLL,
453: per_all_assignments_f ASSIGNMENT,
454: per_time_period_types PERIOD_TYPE
455: where assignment.assignment_id = l_assignment_id
456: and assignment.effective_start_date <= l_end_of_relevant_period
457: and assignment.effective_end_date >= l_start_of_relevant_period
458: and payroll.payroll_id = assignment.payroll_id

Line 750: per_time_period_types PERIOD_TYPE

746: cursor csr_number_of_days is
747: select period_type.number_per_fiscal_year fiscal_year
748: from pay_all_payrolls_f PAYROLL,
749: per_all_assignments_f ASSIGNMENT,
750: per_time_period_types PERIOD_TYPE
751: where assignment.assignment_id = l_assignment_id
752: and payroll.payroll_id = assignment.payroll_id
753: and payroll.period_type = period_type.period_type
754: and payroll.effective_start_date <= l_end_of_relevant_period