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 115.9 2003/11/20 20:09:53 tmehra noship $ */
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 60: CREATE OR REPLACE PACKAGE BODY pay_us_sqwl_udf as

56: REM employer.
57: REM - get_archived_emp_code
58: REM ========================================================================
59:
60: CREATE OR REPLACE PACKAGE BODY pay_us_sqwl_udf as
61: */
62: FUNCTION get_qtr_hire_flag
63: (
64: p_emp_per_hire_date in DATE,

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

174: p_org_information1 varchar2
175: ) IS
176:
177: --
178: l_proc varchar2(100) := 'pay_us_sqwl_udf.chk_for_default_wp';
179:
180: l_count number := 0;
181: --
182: CURSOR c1 (p_organization_id number,

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

302: p_assignment_action_id number DEFAULT NULL
303: ) RETURN BOOLEAN IS
304:
305: --
306: l_proc varchar2(100) := 'pay_us_sqwl_udf.chk_govt_employer';
307: l_tax_unit_id number;
308: l_yes_no boolean := FALSE;
309: --
310: CURSOR c_get_tax_unit_id IS

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

376: p_ss_wh number DEFAULT NULL
377: ) RETURN varchar2 IS
378:
379: --
380: l_proc varchar2(100) := 'pay_us_sqwl_udf.get_employement_code';
381: l_tax_unit_id number;
382: l_code varchar2(1);
383: --
384: --

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

428: FUNCTION get_archived_emp_code ( p_assignment_action_id number DEFAULT NULL
429: ) RETURN varchar2 IS
430:
431: --
432: l_proc varchar2(100) := 'pay_us_sqwl_udf.get_archived_emp_code';
433: l_code varchar2(1);
434: l_ue_id NUMBER;
435: --
436: --

Line 484: END pay_us_sqwl_udf;

480: RETURN l_code;
481:
482: END get_archived_emp_code;
483:
484: END pay_us_sqwl_udf;