APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_IN_24Q_ER_RETURNS

Line 1: PACKAGE BODY pay_in_24q_er_returns AS

1: PACKAGE BODY pay_in_24q_er_returns AS
2: /* $Header: pyineqit.pkb 120.19.12020000.2 2012/07/06 11:00:39 vmaripal ship $ */
3: g_debug BOOLEAN ;
4: g_package CONSTANT VARCHAR2(100) := 'pay_in_24q_er_returns.';
5:

Line 4: g_package CONSTANT VARCHAR2(100) := 'pay_in_24q_er_returns.';

1: PACKAGE BODY pay_in_24q_er_returns AS
2: /* $Header: pyineqit.pkb 120.19.12020000.2 2012/07/06 11:00:39 vmaripal ship $ */
3: g_debug BOOLEAN ;
4: g_package CONSTANT VARCHAR2(100) := 'pay_in_24q_er_returns.';
5:
6:
7: --------------------------------------------------------------------------
8: -- --

Line 121: AND pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0')) <> '0.00'

117: AND EXISTS (SELECT 1 FROM pay_assignment_actions paa
118: WHERE paa.payroll_action_id = p_max_action_id
119: AND paa.assignment_action_id = pai.action_context_id)
120: AND pai.action_information1 = p_challan
121: AND pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0')) <> '0.00'
122: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
123: ORDER BY action_information1, action_information2 ASC;
124:
125: l_count NUMBER;

Line 1129: END pay_in_24q_er_returns;

1125: END IF;
1126:
1127: END get_emp_category;
1128:
1129: END pay_in_24q_er_returns;