DBA Data[Home] [Help]

APPS.PQP_NL_ABP_TEMPLATE dependencies on FF_FORMULAS_F

Line 691: ,ff_formulas_f fff

687: CURSOR c_proc_rule IS
688: SELECT psp.status_processing_rule_id
689: FROM pay_status_processing_rules_f psp
690: ,pay_element_types_f pet
691: ,ff_formulas_f fff
692: WHERE psp.element_type_id = pet.element_type_id
693: AND psp.formula_id = fff.formula_id
694: AND trunc(p_scheme_start_date)
695: BETWEEN psp.effective_start_date AND psp.effective_end_date

Line 716: FROM ff_formulas_f

712: effective_start_date AND effective_end_date;
713:
714: CURSOR c_abp_ff IS
715: SELECT formula_id
716: FROM ff_formulas_f
717: WHERE formula_name = 'ABP_PENSION_INFORMATION'
718: AND legislation_code = 'NL'
719: AND trunc(p_scheme_start_date) BETWEEN
720: effective_start_date AND effective_end_date;