DBA Data[Home] [Help]

APPS.JL_JLARTSFF_XMLP_PKG dependencies on JL_ZZ_AR_TX_CATEGRY

Line 67: JL_ZZ_AR_TX_CATEGRY

63: SELECT
64: TAX_CATEGORY_ID
65: INTO L_VAT_ID
66: FROM
67: JL_ZZ_AR_TX_CATEGRY
68: WHERE TAX_CATEGORY = P_VAT
69: AND ROWNUM = 1;
70: EXCEPTION
71: WHEN OTHERS THEN

Line 81: JL_ZZ_AR_TX_CATEGRY

77: SELECT
78: TAX_CATEGORY_ID
79: INTO L_VATPERC_ID
80: FROM
81: JL_ZZ_AR_TX_CATEGRY
82: WHERE TAX_CATEGORY = P_VATPERC
83: AND ROWNUM = 1;
84: EXCEPTION
85: WHEN OTHERS THEN

Line 95: JL_ZZ_AR_TX_CATEGRY

91: SELECT
92: TAX_CATEGORY_ID
93: INTO L_VATADDL_ID
94: FROM
95: JL_ZZ_AR_TX_CATEGRY
96: WHERE TAX_CATEGORY = P_VATADDL
97: AND ROWNUM = 1;
98: EXCEPTION
99: WHEN OTHERS THEN

Line 109: JL_ZZ_AR_TX_CATEGRY

105: SELECT
106: TAX_CATEGORY_ID
107: INTO L_EXC_ID
108: FROM
109: JL_ZZ_AR_TX_CATEGRY
110: WHERE TAX_CATEGORY = P_EXCISE
111: AND ROWNUM = 1;
112: EXCEPTION
113: WHEN OTHERS THEN

Line 123: JL_ZZ_AR_TX_CATEGRY

119: SELECT
120: TAX_CATEGORY_ID
121: INTO L_VATNOT_ID
122: FROM
123: JL_ZZ_AR_TX_CATEGRY
124: WHERE TAX_CATEGORY = P_VATNOT
125: AND ROWNUM = 1;
126: EXCEPTION
127: WHEN OTHERS THEN

Line 137: JL_ZZ_AR_TX_CATEGRY

133: SELECT
134: TAX_CATEGORY_ID
135: INTO L_NON_TAX_ID
136: FROM
137: JL_ZZ_AR_TX_CATEGRY
138: WHERE TAX_CATEGORY = P_VAT_NON_TAXABLE
139: AND ROWNUM = 1;
140: EXCEPTION
141: WHEN OTHERS THEN