DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on FND_PRODUCT_INSTALLATIONS

Line 110: FROM fnd_application a,fnd_product_installations p

106: , to_char(b.earnings_not_liable_for_acc_ep*100) -- earnings_not_liable_for_acc_ep
107: -- Changes for bug 9237657 start
108: , 'PAYROLL_PACKAGE_VERSION=P'
109: , ( SELECT decode(substr(PRODUCT_VERSION,1,2),'11','Oracle HRMS V11i','Oracle HRMS V12')
110: FROM fnd_application a,fnd_product_installations p
111: WHERE a.application_id = p.application_id
112: AND substr(a.application_short_name, 1, 3) = 'PAY') -- Payroll Package Version
113: , 'PAYROLL_CONTACT_EMAIL=P'
114: , decode(instr(substr(oi.org_information5,