eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_EOY_ER_RETURNS dependencies on HR_ORGANIZATION_INFORMATION

Line 23: FROM hr_organization_information ch_b

19:
20: CURSOR c_count
21: IS
22: SELECT COUNT(*)
23: FROM hr_organization_information ch_b
24: , hr_organization_information it_ch
25: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
26: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
27: AND it_ch.organization_id = p_gre_org_id

Line 24: , hr_organization_information it_ch

20: CURSOR c_count
21: IS
22: SELECT COUNT(*)
23: FROM hr_organization_information ch_b
24: , hr_organization_information it_ch
25: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
26: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
27: AND it_ch.organization_id = p_gre_org_id
28: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(p_assess_year,1,4)) - 1)||'-'||SUBSTR(p_assess_year,1,4))

Line 234: FROM hr_organization_information ch_b

230: , SUM(NVL(it_ch.org_information7,0)) SUR
231: , SUM(NVL(it_ch.org_information8,0)) EC
232: , SUM(NVL(it_ch.org_information9,0)) INTR
233: , SUM(NVL(it_ch.org_information10,0)) OTH
234: FROM hr_organization_information ch_b
235: , hr_organization_information it_ch
236: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
237: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
238: AND it_ch.organization_id = p_gre_org_id

Line 235: , hr_organization_information it_ch

231: , SUM(NVL(it_ch.org_information8,0)) EC
232: , SUM(NVL(it_ch.org_information9,0)) INTR
233: , SUM(NVL(it_ch.org_information10,0)) OTH
234: FROM hr_organization_information ch_b
235: , hr_organization_information it_ch
236: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
237: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
238: AND it_ch.organization_id = p_gre_org_id
239: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(p_assess_year,1,4)) - 1)||'-'||SUBSTR(p_assess_year,1,4))

Line 534: FROM hr_organization_information

530: RETURN VARCHAR2 IS
531:
532: CURSOR c_employer IS
533: SELECT org_information3
534: FROM hr_organization_information
535: WHERE org_information_context = 'PER_IN_INCOME_TAX_DF'
536: AND organization_id = p_gre_org_id;
537:
538: l_emplr_class VARCHAR2(150);