APPS.BEN_DERIVE_FACTORS dependencies on BEN_PER_BNFTS_BAL_F

Line 624: from ben_per_bnfts_bal_f pbb,

620: --
621:
622: cursor c_person_balance(p_date date) is
623: select pbb.val, bnb.name
624: from ben_per_bnfts_bal_f pbb,
625: ben_bnfts_bal_f bnb
626: where pbb.person_id = p_person_id
627: and pbb.business_group_id = p_business_group_id
628: and pbb.bnfts_bal_id = bnb.bnfts_bal_id

Line 2769: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;

2765: --
2766: l_package VARCHAR2(80) := g_package || '.determine_hours_worked';
2767: l_start_date DATE;
2768: l_result NUMBER;
2769: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
2770: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;
2771: l_jurisdiction_code VARCHAR2(30);
2772: l_min_ass_date date ;
2773: l_effective_date date ;