APPS.BEN_DERIVE_FACTORS dependencies on BEN_PER_BNFTS_BAL_F

Line 639: from ben_per_bnfts_bal_f pbb,

635: --
636:
637: cursor c_person_balance(p_date date) is
638: select pbb.val, bnb.name
639: from ben_per_bnfts_bal_f pbb,
640: ben_bnfts_bal_f bnb
641: where pbb.person_id = p_person_id
642: and pbb.business_group_id = p_business_group_id
643: and pbb.bnfts_bal_id = bnb.bnfts_bal_id

Line 2890: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;

2886: --
2887: l_package VARCHAR2(80) := g_package || '.determine_hours_worked';
2888: l_start_date DATE;
2889: l_result NUMBER;
2890: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
2891: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;
2892: l_jurisdiction_code VARCHAR2(30);
2893: l_min_ass_date date ;
2894: l_effective_date date ;