DBA Data[Home] [Help]

APPS.PAY_PEL_BUS dependencies on BEN_BENEFIT_CLASSIFICATIONS

Line 843: from ben_benefit_classifications bbc, pay_element_types_f pet

839: ) is
840: --
841: cursor csr_ben_contri_used is
842: select '1'
843: from ben_benefit_classifications bbc, pay_element_types_f pet
844: where bbc.benefit_classification_id(+) = pet.benefit_classification_id
845: and element_type_id = p_element_type_id
846: and p_effective_start_date between pet.effective_start_date
847: and pet.effective_end_date