DBA Data[Home] [Help]

APPS.PAY_PAYJPITT_XMLP_PKG dependencies on PAY_JP_WIC_PKG

Line 6: L_CERTIFICATE_INFO PAY_JP_WIC_PKG.T_TAX_INFO;

2: /* $Header: PAYJPITTB.pls 120.3 2008/04/24 11:22:20 amakrish noship $ */
3:
4: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
5: L_SUBMISSION_REQUIRED_FLAG VARCHAR2(1);
6: L_CERTIFICATE_INFO PAY_JP_WIC_PKG.T_TAX_INFO;
7: L_WITHHOLDING_TAX_INFO PAY_JP_WIC_PKG.T_TAX_INFO;
8: -- L_PREV_JOBS PAY_JP_WIC_PKG.T_PREV_JOBS;
9: -- L_PREV_JOBS_COUNT NUMBER;
10: -- L_WITHHOLDING_TAX NUMBER;

Line 7: L_WITHHOLDING_TAX_INFO PAY_JP_WIC_PKG.T_TAX_INFO;

3:
4: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
5: L_SUBMISSION_REQUIRED_FLAG VARCHAR2(1);
6: L_CERTIFICATE_INFO PAY_JP_WIC_PKG.T_TAX_INFO;
7: L_WITHHOLDING_TAX_INFO PAY_JP_WIC_PKG.T_TAX_INFO;
8: -- L_PREV_JOBS PAY_JP_WIC_PKG.T_PREV_JOBS;
9: -- L_PREV_JOBS_COUNT NUMBER;
10: -- L_WITHHOLDING_TAX NUMBER;
11: CURSOR CSR_ASSACT IS

Line 8: -- L_PREV_JOBS PAY_JP_WIC_PKG.T_PREV_JOBS;

4: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
5: L_SUBMISSION_REQUIRED_FLAG VARCHAR2(1);
6: L_CERTIFICATE_INFO PAY_JP_WIC_PKG.T_TAX_INFO;
7: L_WITHHOLDING_TAX_INFO PAY_JP_WIC_PKG.T_TAX_INFO;
8: -- L_PREV_JOBS PAY_JP_WIC_PKG.T_PREV_JOBS;
9: -- L_PREV_JOBS_COUNT NUMBER;
10: -- L_WITHHOLDING_TAX NUMBER;
11: CURSOR CSR_ASSACT IS
12: SELECT ASSIGNMENT_ACTION_ID,

Line 52: PAY_JP_WIC_PKG.GET_CERTIFICATE_INFO(

48: AND HOI1.ORG_INFORMATION_CONTEXT(+) = 'JP_TAX_SWOT_INFO'
49: AND HOI2.ORGANIZATION_ID(+) = HOU.ORGANIZATION_ID
50: AND HOI2.ORG_INFORMATION_CONTEXT(+) = 'JP_ITAX_WITHHELD_INFO';
51: FOR L_REC IN CSR_ASSACT LOOP
52: PAY_JP_WIC_PKG.GET_CERTIFICATE_INFO(
53: P_ASSIGNMENT_ACTION_ID => L_REC.ASSIGNMENT_ACTION_ID,
54: P_ASSIGNMENT_ID => L_REC.ASSIGNMENT_ID,
55: P_ACTION_SEQUENCE => L_REC.ACTION_SEQUENCE,
56: P_EFFECTIVE_DATE => L_REC.EFFECTIVE_DATE,