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.10.12010000.2 2008/09/04 15:03:53 rsaharay 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.10.12010000.2 2008/09/04 15:03:53 rsaharay ship $ */
3: g_debug BOOLEAN ;
4: g_package CONSTANT VARCHAR2(100) := 'pay_in_24q_er_returns.';
5:
6:
7: --------------------------------------------------------------------------
8: -- --

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

95: AND EXISTS (SELECT 1 FROM pay_assignment_actions paa
96: WHERE paa.payroll_action_id = p_max_action_id
97: AND paa.assignment_action_id = pai.action_context_id)
98: AND pai.action_information1 = p_challan
99: AND pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0')) <> '0.00'
100: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
101: ORDER BY action_information1, action_information2 ASC;
102:
103: l_count NUMBER;

Line 1075: END pay_in_24q_er_returns;

1071: END IF;
1072:
1073: END get_emp_category;
1074:
1075: END pay_in_24q_er_returns;