DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PER_POSITION_STRUCTURES

Line 1511: from PER_POSITION_STRUCTURES pos,

1507: --
1508: cursor c_PositionStructureNameLovVO(p_source_name1 varchar2, cv_effective_date date) is
1509: select pos.NAME name,
1510: POS_STRUCTURE_VERSION_ID id
1511: from PER_POSITION_STRUCTURES pos,
1512: PER_POS_STRUCTURE_VERSIONS pov
1513: where pos.POSITION_STRUCTURE_ID = pov.POSITION_STRUCTURE_ID
1514: and trunc(cv_effective_date)
1515: between POV.DATE_FROM and nvl(POV.DATE_TO, trunc(cv_effective_date))