DBA Data[Home] [Help]

APPS.PAY_MX_CURRENCY_CONVERSION dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 83: FROM ben_pil_elctbl_chc_popl

79: WHERE business_group_id = cp_business_group_id;
80:
81: CURSOR c_ben_chc_popl( cp_business_group_id NUMBER ) IS
82: SELECT rowid
83: FROM ben_pil_elctbl_chc_popl
84: WHERE business_group_id = cp_business_group_id;
85:
86: CURSOR c_ben_elig_per( cp_business_group_id NUMBER ) IS
87: SELECT rowid

Line 602: /* BEN_PIL_ELCTBL_CHC_POPL */

598: output_currency_code = lv_old_currency );
599:
600: END LOOP;
601:
602: /* BEN_PIL_ELCTBL_CHC_POPL */
603:
604: ln_commit_cnt := 0;
605:
606: FOR chc IN c_ben_chc_popl( ln_business_group_id )

Line 609: UPDATE ben_pil_elctbl_chc_popl

605:
606: FOR chc IN c_ben_chc_popl( ln_business_group_id )
607: LOOP
608:
609: UPDATE ben_pil_elctbl_chc_popl
610: SET uom = lv_new_currency
611: WHERE rowid = chc.rowid
612: AND uom = lv_old_currency;
613: