APPS.PAY_IE_SOE dependencies on PAY_IE_SOE

Line 1: PACKAGE BODY PAY_IE_SOE AS

1: PACKAGE BODY PAY_IE_SOE AS
2: /* $Header: pyiesoer.pkb 120.3 2012/01/19 09:45:45 rpahune ship $ */
3: g_package CONSTANT varchar2(33) := ' PAY_IE_SOE.';
4: l_sql long;
5: g_debug CONSTANT boolean := hr_utility.debug_enabled;

Line 3: g_package CONSTANT varchar2(33) := ' PAY_IE_SOE.';

1: PACKAGE BODY PAY_IE_SOE AS
2: /* $Header: pyiesoer.pkb 120.3 2012/01/19 09:45:45 rpahune ship $ */
3: g_package CONSTANT varchar2(33) := ' PAY_IE_SOE.';
4: l_sql long;
5: g_debug CONSTANT boolean := hr_utility.debug_enabled;
6: function setParameters(p_person_id in number, p_assignment_id in number, p_effective_date date) return varchar2 is
7: p_payroll_exists varchar2(10);

Line 111: from PAY_IE_SOE_PAYE_DETAILS_V PSPD

107: ,PSPD.D_TAX_ASSESS_BASIS COL04
108: ,PTM.PERIOD_NUM COL16
109: ,Decode(PTPR.BASIC_PERIOD_TYPE,''CM'',PSPD.MONTHLY_STD_RATE_CUT_OFF*PTPR.NUMBER_PER_FISCAL_YEAR/12,''W'',PSPD.WEEKLY_STD_RATE_CUT_OFF*PTPR.NUMBER_PER_FISCAL_YEAR/52) COL17
110: ,Decode(PTPR.BASIC_PERIOD_TYPE,''CM'',PSPD.MONTHLY_TAX_CREDIT*PTPR.NUMBER_PER_FISCAL_YEAR/12,''W'',PSPD.WEEKLY_TAX_CREDIT*PTPR.NUMBER_PER_FISCAL_YEAR/52) COL18
111: from PAY_IE_SOE_PAYE_DETAILS_V PSPD
112: ,PAY_PAYROLL_ACTIONS PPA
113: ,PAY_ASSIGNMENT_ACTIONS PAAS
114: ,PER_TIME_PERIODS PTM
115: ,PER_TIME_PERIOD_TYPES PTPT

Line 133: from PAY_IE_SOE_PRSI_DETAILS_V PSPD

129: begin
130: l_sql:=
131: 'select PSPD.CONTRIBUTION_CLASS COL01
132: , OVERRIDDEN_SUBCLASS COL02
133: from PAY_IE_SOE_PRSI_DETAILS_V PSPD
134: where PSPD.assignment_action_id :action_clause';
135: return l_sql;
136: end PRSI_Info;
137: --

Line 263: from PAY_IE_SOE_PRSI_DETAILS_V PSPD

259:
260: Cursor c_PRSI(a_asg_action_id number) is
261: select PSPD.CONTRIBUTION_CLASS con
262: , OVERRIDDEN_SUBCLASS ovr
263: from PAY_IE_SOE_PRSI_DETAILS_V PSPD
264: where PSPD.assignment_action_id=a_asg_action_id;
265:
266: /* Added for bug 4287903 */
267: /* Added number_per_fiscal_year for 4354386*/

Line 319: from PAY_IE_SOE_PAYE_DETAILS_V PSPD

315: ,Decode('''|| v_basic_period_type|| ''',''CM'',PSPD.MONTHLY_STD_RATE_CUT_OFF*' || v_number_per_fiscal_year || '/12,''W'',PSPD.WEEKLY_STD_RATE_CUT_OFF*' || v_number_per_fiscal_year || '/52) COL05
316: ,Decode('''|| v_basic_period_type|| ''',''CM'',PSPD.MONTHLY_TAX_CREDIT*' || v_number_per_fiscal_year || '/12,''W'',PSPD.WEEKLY_TAX_CREDIT*' || v_number_per_fiscal_year || '/52) COL06
317: ,''' ||v_contribution_class || ''' COL08
318: ,''' ||v_overridden_class || ''' COL09
319: from PAY_IE_SOE_PAYE_DETAILS_V PSPD
320: where PSPD.assignment_action_id :action_clause';
321:
322: return l_sql;
323: end Tax_PRSI_Info;

Line 325: END PAY_IE_SOE;

321:
322: return l_sql;
323: end Tax_PRSI_Info;
324:
325: END PAY_IE_SOE;