APPS.PER_RU_CURRENCY_CONVERSION dependencies on PAY_GL_INTERFACE

Line 31: CURSOR c_pay_gl_interface ( cp_business_group_id NUMBER ) IS

27: AND pps.patch_name = 'Currency_Conversion_for_Russia'
28: AND pps.legislation_code = 'RU'
29: AND pps.status = 'C' );
30:
31: CURSOR c_pay_gl_interface ( cp_business_group_id NUMBER ) IS
32: SELECT pgi.assignment_action_id
33: FROM pay_gl_interface pgi
34: ,pay_payroll_actions ppa
35: WHERE ppa.business_group_id = cp_business_group_id

Line 33: FROM pay_gl_interface pgi

29: AND pps.status = 'C' );
30:
31: CURSOR c_pay_gl_interface ( cp_business_group_id NUMBER ) IS
32: SELECT pgi.assignment_action_id
33: FROM pay_gl_interface pgi
34: ,pay_payroll_actions ppa
35: WHERE ppa.business_group_id = cp_business_group_id
36: AND pgi.run_payroll_action_id = ppa.payroll_action_id;
37:

Line 523: /* PAY_GL_INTERFACE */

519: SET currency_code = lv_new_currency
520: WHERE business_group_id = ln_business_group_id
521: AND currency_code = lv_old_currency;
522:
523: /* PAY_GL_INTERFACE */
524:
525: ln_commit_cnt := 0;
526:
527: FOR paygl IN c_pay_gl_interface( ln_business_group_id )

Line 527: FOR paygl IN c_pay_gl_interface( ln_business_group_id )

523: /* PAY_GL_INTERFACE */
524:
525: ln_commit_cnt := 0;
526:
527: FOR paygl IN c_pay_gl_interface( ln_business_group_id )
528: LOOP
529:
530: UPDATE pay_gl_interface
531: SET currency_code = lv_new_currency

Line 530: UPDATE pay_gl_interface

526:
527: FOR paygl IN c_pay_gl_interface( ln_business_group_id )
528: LOOP
529:
530: UPDATE pay_gl_interface
531: SET currency_code = lv_new_currency
532: WHERE assignment_action_id = paygl.assignment_action_id
533: AND currency_code = lv_old_currency;
534: