DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 29: hr_all_organization_units_tl bptl,

25: from hr_organization_information hoi3,
26: hr_organization_units corp,
27: hr_organization_information hoi2,
28: hr_organization_information hoi1,
29: hr_all_organization_units_tl bptl,
30: hr_organization_units bp
31: where bp.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
32: and bptl.organization_id = bp.organization_id
33: and bptl.language = userenv('LANG')

Line 54: hr_all_organization_units_tl bptl2,

50: 'AMT_SUB_EXEM=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'AMT_SUB_EXEM'),
51: 'REP_PERIOD_CODE=P', g_rep_period_code
52: from hr_organization_information hoi3,
53: hr_organization_information hoi2,
54: hr_all_organization_units_tl bptl2,
55: hr_organization_units bp2,
56: hr_organization_information hoi1,
57: hr_organization_units bp1
58: where bp1.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')