APPS.PAY_MX_CURRENCY_CONVERSION dependencies on PAY_PATCH_STATUS

Line 58: FROM pay_patch_status pps

54: AND hoi1.org_information_context = 'CLASS'
55: AND hoi1.org_information1 = 'HR_BG'
56: AND hoi1.org_information2 = 'Y'
57: AND NOT EXISTS ( SELECT 1
58: FROM pay_patch_status pps
59: WHERE pps.patch_number = to_char(hoi.organization_id)
60: AND pps.patch_name = 'Currency_Conversion_for_Mexico'
61: AND pps.legislation_code = 'MX'
62: AND pps.status = 'C' );

Line 652: INSERT INTO pay_patch_status

648: WHERE organization_id = ln_business_group_id
649: AND org_information_context = 'Business Group Information'
650: AND org_information10 = lv_old_currency;
651:
652: INSERT INTO pay_patch_status
653: (id, patch_number, patch_name, applied_date, status,
654: description, update_date, legislation_code)
655: VALUES (pay_patch_status_s.nextval, to_char(ln_business_group_id),
656: 'Currency_Conversion_for_Mexico', sysdate, 'C',

Line 655: VALUES (pay_patch_status_s.nextval, to_char(ln_business_group_id),

651:
652: INSERT INTO pay_patch_status
653: (id, patch_number, patch_name, applied_date, status,
654: description, update_date, legislation_code)
655: VALUES (pay_patch_status_s.nextval, to_char(ln_business_group_id),
656: 'Currency_Conversion_for_Mexico', sysdate, 'C',
657: lv_business_group_name, sysdate, 'MX');
658:
659: END LOOP;