DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on PAY_KR_YEA_DON_EFILE_CONC_PKG

Line 47: 'C_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),

43: cursor csr_b is
44: select DISTINCT 'BP_NUMBER=P', hoi2.org_information2,
45: 'BP_NAME=P', hoi2.org_information1,
46: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
47: 'C_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
48: 'D_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
49: 'DON_AMT=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'DON_AMT'),
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

Line 48: 'D_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),

44: select DISTINCT 'BP_NUMBER=P', hoi2.org_information2,
45: 'BP_NAME=P', hoi2.org_information1,
46: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
47: 'C_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
48: 'D_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
49: 'DON_AMT=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'DON_AMT'),
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,

Line 49: 'DON_AMT=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'DON_AMT'),

45: 'BP_NAME=P', hoi2.org_information1,
46: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
47: 'C_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
48: 'D_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
49: 'DON_AMT=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'DON_AMT'),
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,

Line 50: 'AMT_SUB_EXEM=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'AMT_SUB_EXEM'),

46: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
47: 'C_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
48: 'D_RECORDS=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
49: 'DON_AMT=P', pay_kr_yea_don_efile_conc_pkg.record_count(hoi2.org_information2, hoi3.org_information9, 'DON_AMT'),
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,