APPS.PER_RU_CURRENCY_CONVERSION dependencies on PAY_PATCH_STATUS

Line 25: FROM pay_patch_status pps

21: AND hoi1.org_information_context = 'CLASS'
22: AND hoi1.org_information1 = 'HR_BG'
23: AND hoi1.org_information2 = 'Y'
24: AND NOT EXISTS ( SELECT 1
25: FROM pay_patch_status pps
26: WHERE pps.patch_number = to_char(hoi.organization_id)
27: AND pps.patch_name = 'Currency_Conversion_for_Russia'
28: AND pps.legislation_code = 'RU'
29: AND pps.status = 'C' );

Line 619: INSERT INTO pay_patch_status

615: WHERE organization_id = ln_business_group_id
616: AND org_information_context = 'Business Group Information'
617: AND org_information10 = lv_old_currency;
618:
619: INSERT INTO pay_patch_status
620: (id, patch_number, patch_name, applied_date, status,
621: description, update_date, legislation_code)
622: VALUES (pay_patch_status_s.nextval, to_char(ln_business_group_id),
623: 'Currency_Conversion_for_Russia', sysdate, 'C',

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

618:
619: INSERT INTO pay_patch_status
620: (id, patch_number, patch_name, applied_date, status,
621: description, update_date, legislation_code)
622: VALUES (pay_patch_status_s.nextval, to_char(ln_business_group_id),
623: 'Currency_Conversion_for_Russia', sysdate, 'C',
624: lv_business_group_name, sysdate, 'RU');
625:
626: END LOOP;