DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PAY_ELEMENT_TYPES_F

Line 1540: from pay_element_types_f pet,

1536: --
1537: cursor c_ElementTypeLovVO(p_source_name1 varchar2, cv_effective_date date) is
1538: select pett.element_name name
1539: ,pett.element_type_id id
1540: from pay_element_types_f pet,
1541: pay_element_types_f_tl pett
1542: where trunc(cv_effective_date)
1543: between nvl(pet.effective_start_date,trunc(cv_effective_date)) and nvl
1544: (pet.effective_end_date,trunc(cv_effective_date ))

Line 1541: pay_element_types_f_tl pett

1537: cursor c_ElementTypeLovVO(p_source_name1 varchar2, cv_effective_date date) is
1538: select pett.element_name name
1539: ,pett.element_type_id id
1540: from pay_element_types_f pet,
1541: pay_element_types_f_tl pett
1542: where trunc(cv_effective_date)
1543: between nvl(pet.effective_start_date,trunc(cv_effective_date)) and nvl
1544: (pet.effective_end_date,trunc(cv_effective_date ))
1545: and pet.element_type_id=pett.element_type_id