APPS.PAY_US_SQWL_UDF dependencies on PAY_US_SQWL_UDF

Line 1: PACKAGE BODY pay_us_sqwl_udf as

1: PACKAGE BODY pay_us_sqwl_udf as
2: /* $Header: pyussqut.pkb 120.6.12020000.9 2013/03/26 06:46:06 schowl ship $ */
3: /* +======================================================================+
4: REM | Copyright (c) 1997 Oracle Corporation |
5: REM | Redwood Shores, California, USA |

Line 11: REM Package Name : pay_us_sqwl_udf

7: REM +======================================================================+
8: REM SQL Script File Name : pyussqut.pkb
9: REM Description : Package and procedure to build sql for payroll
10: REM processes.
11: REM Package Name : pay_us_sqwl_udf
12: REM Purpose : Using the transfer_date and A_EMP_PER_HIRE_DATE,
13: REM this function will determine if the hire date is
14: REM within the quarter defined by the transfer_date.
15: REM Arguments : 1. A_EMP_PER_HIRE_DATE,

Line 91: CREATE OR REPLACE PACKAGE BODY pay_us_sqwl_udf as

87: REM schowl 26-Mar-2013 115.23 14345202 Modified 'get_ca_sqwl_wages' to support different Wage plan
88: REM codes. Modified 'spl_char_check'.
89: REM ===============================================================================================================
90:
91: CREATE OR REPLACE PACKAGE BODY pay_us_sqwl_udf as
92: */
93: FUNCTION get_qtr_hire_flag
94: (
95: p_emp_per_hire_date in DATE,

Line 209: l_proc varchar2(100) := 'pay_us_sqwl_udf.chk_for_default_wp';

205: p_org_information1 varchar2
206: ) IS
207:
208: --
209: l_proc varchar2(100) := 'pay_us_sqwl_udf.chk_for_default_wp';
210:
211: l_count number := 0;
212: --
213: CURSOR c1 (p_organization_id number,

Line 337: l_proc varchar2(100) := 'pay_us_sqwl_udf.chk_govt_employer';

333: p_assignment_action_id number DEFAULT NULL
334: ) RETURN BOOLEAN IS
335:
336: --
337: l_proc varchar2(100) := 'pay_us_sqwl_udf.chk_govt_employer';
338: l_tax_unit_id number;
339: l_yes_no boolean := FALSE;
340: --
341: CURSOR c_get_tax_unit_id IS

Line 411: l_proc varchar2(100) := 'pay_us_sqwl_udf.get_employement_code';

407: p_ss_wh number DEFAULT NULL
408: ) RETURN varchar2 IS
409:
410: --
411: l_proc varchar2(100) := 'pay_us_sqwl_udf.get_employement_code';
412: l_tax_unit_id number;
413: l_code varchar2(1);
414: --
415: --

Line 463: l_proc varchar2(100) := 'pay_us_sqwl_udf.get_archived_emp_code';

459: FUNCTION get_archived_emp_code ( p_assignment_action_id number DEFAULT NULL
460: ) RETURN varchar2 IS
461:
462: --
463: l_proc varchar2(100) := 'pay_us_sqwl_udf.get_archived_emp_code';
464: l_code varchar2(1);
465: l_ue_id NUMBER;
466: --
467: --

Line 1427: END pay_us_sqwl_udf;

1423: return l_stripped_value;
1424:
1425: END spl_char_check;
1426:
1427: END pay_us_sqwl_udf;