APPS.PAY_MX_CURRENCY_CONVERSION dependencies on PAY_GL_INTERFACE

Line 64: CURSOR c_pay_gl_interface ( cp_business_group_id NUMBER ) IS

60: AND pps.patch_name = 'Currency_Conversion_for_Mexico'
61: AND pps.legislation_code = 'MX'
62: AND pps.status = 'C' );
63:
64: CURSOR c_pay_gl_interface ( cp_business_group_id NUMBER ) IS
65: SELECT pgi.assignment_action_id
66: FROM pay_gl_interface pgi
67: ,pay_payroll_actions ppa
68: WHERE ppa.business_group_id = cp_business_group_id

Line 66: FROM pay_gl_interface pgi

62: AND pps.status = 'C' );
63:
64: CURSOR c_pay_gl_interface ( cp_business_group_id NUMBER ) IS
65: SELECT pgi.assignment_action_id
66: FROM pay_gl_interface pgi
67: ,pay_payroll_actions ppa
68: WHERE ppa.business_group_id = cp_business_group_id
69: AND pgi.run_payroll_action_id = ppa.payroll_action_id;
70:

Line 556: /* PAY_GL_INTERFACE */

552: SET currency_code = lv_new_currency
553: WHERE business_group_id = ln_business_group_id
554: AND currency_code = lv_old_currency;
555:
556: /* PAY_GL_INTERFACE */
557:
558: ln_commit_cnt := 0;
559:
560: FOR paygl IN c_pay_gl_interface( ln_business_group_id )

Line 560: FOR paygl IN c_pay_gl_interface( ln_business_group_id )

556: /* PAY_GL_INTERFACE */
557:
558: ln_commit_cnt := 0;
559:
560: FOR paygl IN c_pay_gl_interface( ln_business_group_id )
561: LOOP
562:
563: UPDATE pay_gl_interface
564: SET currency_code = lv_new_currency

Line 563: UPDATE pay_gl_interface

559:
560: FOR paygl IN c_pay_gl_interface( ln_business_group_id )
561: LOOP
562:
563: UPDATE pay_gl_interface
564: SET currency_code = lv_new_currency
565: WHERE assignment_action_id = paygl.assignment_action_id
566: AND currency_code = lv_old_currency;
567: