DBA Data[Home] [Help]

APPS.PAY_MX_CURRENCY_CONVERSION dependencies on BEN_ELIG_PER_F

Line 88: FROM ben_elig_per_f

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
88: FROM ben_elig_per_f
89: WHERE business_group_id = cp_business_group_id;
90:
91: ln_business_group_id NUMBER;
92: lv_business_group_name VARCHAR2(400);

Line 623: /* BEN_ELIG_PER_F */

619: END IF;
620:
621: END LOOP;
622:
623: /* BEN_ELIG_PER_F */
624:
625: ln_commit_cnt := 0;
626:
627: FOR elig IN c_ben_elig_per( ln_business_group_id )

Line 630: UPDATE ben_elig_per_f

626:
627: FOR elig IN c_ben_elig_per( ln_business_group_id )
628: LOOP
629:
630: UPDATE ben_elig_per_f
631: SET rt_comp_ref_uom = lv_new_currency
632: WHERE rowid = elig.rowid
633: AND rt_comp_ref_uom = lv_old_currency;
634: