eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_PAYE_PKG dependencies on PAY_IE_PAYE_DETAILS_F

Line 60: ** date to fetch paye values from pay_ie_paye_details_f.

56: ** Changed p_effective_date for Correction cases.
57: ** 23-Feb-2005 skhandwa 4080773 Modified the proc update_paye_change_freq
58: ** Added assignment start date check for Correction cases .
59: ** 20-Apr-2005 alikhar 3227184 Changed cursor c_paye_dtl to use the payroll effective
60: ** date to fetch paye values from pay_ie_paye_details_f.
61: ** 26-Sep-2005 rrajaman 4619038 Added checks for new Tax Basis IE_EXEMPTION.
62: ** 04-Oct-2005 rrajaman 4561012 Added checks for IE_WEEK1_MONTH1.
63: ** 15-Dec-2005 vikgupta 4878630 Modified the update_paye_change_freq proc
64: ** for tax credit upload process.

Line 122: from pay_ie_paye_details_f pipd

118:
119:
120: -- cursor to fetch tax basis
121: cursor c_paye_tax_basis is select tax_basis
122: from pay_ie_paye_details_f pipd
123: ,pay_payroll_actions ppa
124: ,per_time_periods ptp
125: where pipd.assignment_id = p_assignment_id
126: and ppa.payroll_action_id = p_payroll_action_id

Line 177: ,pay_ie_paye_details_f pipd

173: CURSOR chk_multi_asgn_tax_basis IS
174: SELECT 1
175: FROM per_all_assignments_f paaf
176: ,per_time_periods ptp
177: ,pay_ie_paye_details_f pipd
178: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
179: AND paaf.assignment_id <> p_assignment_id
180: AND pipd.assignment_id(+) = paaf.assignment_id
181: AND nvl(pipd.tax_basis,'X') <> 'IE_EXCLUDE'

Line 227: ,pay_ie_paye_details_f pipd

223: CURSOR chk_multi_asgn_tax_basis IS
224: SELECT 1
225: FROM per_all_assignments_f paaf
226: ,per_time_periods ptp
227: ,pay_ie_paye_details_f pipd
228: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
229: AND paaf.assignment_id <> p_assignment_id
230: AND pipd.assignment_id(+) = paaf.assignment_id
231: AND nvl(pipd.tax_basis,'X') = 'IE_EXCLUDE'

Line 315: from pay_ie_paye_details_f pipd

311: /*changes for SOE form requirements*/
312: ,pipd.tax_assess_basis
313: ,nvl(pipd.certificate_issue_date,to_date('01-01-0001','DD-MM-YYYY'))
314: ,ptp.period_type
315: from pay_ie_paye_details_f pipd
316: ,pay_payroll_actions ppa
317: ,per_time_periods ptp
318: where pipd.assignment_id = p_assignment_id
319: and ppa.payroll_action_id = p_payroll_action_id

Line 591: from pay_ie_paye_details_f pipd

587: ,nvl(usc_yrly_cutoff_4 ,0)
588: ,nvl(usc_mthly_cutoff_4 ,0)
589: ,nvl(usc_wkly_cutoff_4 ,0)
590: ,nvl(usc_rate_5 ,0)
591: from pay_ie_paye_details_f pipd
592: ,pay_payroll_actions ppa
593: where pipd.assignment_id = p_assignment_id
594: and ppa.payroll_action_id = p_payroll_action_id
595: and ppa.effective_date between pipd.effective_start_date and

Line 753: from pay_ie_paye_details_f pipd,

749: and ppa.effective_date between pap.effective_start_date and pap.effective_end_date;
750:
751: Cursor csr_emer_no_pps_basis IS
752: SELECT nvl(pipd.tax_basis, 'X')
753: from pay_ie_paye_details_f pipd,
754: pay_payroll_actions ppa
755: WHERE ppa.payroll_action_id = p_payroll_action_id
756: and pipd.assignment_id = p_assignment_id
757: and ppa.effective_date between pipd.effective_start_date and pipd.effective_end_date;

Line 896: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,

892: /* End of BUG 3030621 */
893: /*ADDED FOUR FUNCTIONS FOR BUG 3030616 */
894: --
895: function get_monthly_std_rate_cut_off
896: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,
897: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)
898: RETURN number
899: is
900: CURSOR get_global_val(l_name IN VARCHAR2) IS

Line 897: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)

893: /*ADDED FOUR FUNCTIONS FOR BUG 3030616 */
894: --
895: function get_monthly_std_rate_cut_off
896: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,
897: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)
898: RETURN number
899: is
900: CURSOR get_global_val(l_name IN VARCHAR2) IS
901: SELECT global_value

Line 918: FROM pay_ie_paye_details_f pp,fnd_sessions ses

914: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
915: --
916: CURSOR monthly_std_rate_cut_off IS
917: SELECT nvl(pp.monthly_std_rate_cut_off,0)
918: FROM pay_ie_paye_details_f pp,fnd_sessions ses
919: WHERE pp.assignment_id=p_assignment_id
920: AND ses.session_id = userenv('SESSIONID')
921: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
922: --

Line 958: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,

954: --
955: END get_monthly_std_rate_cut_off;
956: --
957: function get_monthly_tax_credit
958: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,
959: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)
960: RETURN number
961: is
962: CURSOR get_global_val(l_name IN VARCHAR2) IS

Line 959: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)

955: END get_monthly_std_rate_cut_off;
956: --
957: function get_monthly_tax_credit
958: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,
959: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)
960: RETURN number
961: is
962: CURSOR get_global_val(l_name IN VARCHAR2) IS
963: SELECT global_value

Line 980: FROM pay_ie_paye_details_f pp,fnd_sessions ses

976: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
977: --
978: CURSOR monthly_tax_credit IS
979: SELECT nvl(pp.monthly_tax_credit,0)
980: FROM pay_ie_paye_details_f pp,fnd_sessions ses
981: WHERE pp.assignment_id=p_assignment_id
982: AND ses.session_id = userenv('SESSIONID')
983: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
984: --

Line 1025: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,

1021: --
1022: END get_monthly_tax_credit;
1023: --
1024: function get_weekly_std_rate_cut_off
1025: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,
1026: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)
1027: RETURN number
1028: is
1029: CURSOR get_global_val(l_name IN VARCHAR2) IS

Line 1026: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)

1022: END get_monthly_tax_credit;
1023: --
1024: function get_weekly_std_rate_cut_off
1025: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,
1026: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)
1027: RETURN number
1028: is
1029: CURSOR get_global_val(l_name IN VARCHAR2) IS
1030: SELECT global_value

Line 1047: FROM pay_ie_paye_details_f pp,fnd_sessions ses

1043: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
1044: --
1045: CURSOR weekly_std_rate_cut_off IS
1046: SELECT nvl(pp.weekly_std_rate_cut_off,0)
1047: FROM pay_ie_paye_details_f pp,fnd_sessions ses
1048: WHERE pp.assignment_id=p_assignment_id
1049: AND ses.session_id = userenv('SESSIONID')
1050: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
1051: --

Line 1088: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,

1084: --
1085: END get_weekly_std_rate_cut_off;
1086: --
1087: function get_weekly_tax_credit
1088: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,
1089: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)
1090: RETURN number
1091: is
1092: CURSOR get_global_val(l_name IN VARCHAR2) IS

Line 1089: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)

1085: END get_weekly_std_rate_cut_off;
1086: --
1087: function get_weekly_tax_credit
1088: (p_assignment_id in pay_ie_paye_details_f.ASSIGNMENT_ID%TYPE,
1089: p_tax_basis in pay_ie_paye_details_f.TAX_BASIS%TYPE)
1090: RETURN number
1091: is
1092: CURSOR get_global_val(l_name IN VARCHAR2) IS
1093: SELECT global_value

Line 1110: FROM pay_ie_paye_details_f pp,fnd_sessions ses

1106: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
1107: --
1108: CURSOR weekly_tax_credit IS
1109: SELECT nvl(pp.weekly_tax_credit,0)
1110: FROM pay_ie_paye_details_f pp,fnd_sessions ses
1111: WHERE pp.assignment_id=p_assignment_id
1112: AND ses.session_id = userenv('SESSIONID')
1113: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
1114: --

Line 1250: from pay_ie_paye_details_f

1246: --13359423
1247: ) is --4878630
1248:
1249: Cursor c_effective_paye is select *
1250: from pay_ie_paye_details_f
1251: where p_effective_date between effective_start_date and effective_end_date
1252: and assignment_id = p_assignment_id
1253: order by effective_start_date asc;
1254:

Line 1256: from pay_ie_paye_details_f

1252: and assignment_id = p_assignment_id
1253: order by effective_start_date asc;
1254:
1255: cursor c_future_paye(p_paye_details_id number) is select *
1256: from pay_ie_paye_details_f
1257: where p_effective_date < effective_start_date
1258: and assignment_id = p_assignment_id
1259: and ((paye_details_id <> p_paye_details_id and p_paye_details_id is not null) or p_paye_details_id is null )
1260: order by effective_start_date asc;

Line 1265: from pay_ie_paye_details_f

1261:
1262: /* Cusror added for tax credit upload */ --4878630
1263: Cursor c_tax_effective_paye(p_paye_id number,p_date date) is
1264: select *
1265: from pay_ie_paye_details_f
1266: where ((p_date < effective_start_date and trunc(p_date,'Y') = trunc(effective_start_date,'Y') and p_paye_id is null)
1267: or (paye_details_id <> p_paye_id and p_paye_id is not null and p_date < effective_start_date))
1268: and assignment_id = p_assignment_id
1269: order by effective_start_date desc;

Line 1320: l_max_paye_id pay_ie_paye_details_f.paye_details_id%TYPE; --4878630

1316: L_MIN_EFFECTIVE_DATE date;
1317: L_NEW_PAYROLL_ID number;
1318: L_CERTIFICATE_START_DATE date;
1319: l_futrec_effective_end_date date;
1320: l_max_paye_id pay_ie_paye_details_f.paye_details_id%TYPE; --4878630
1321: l_max_effective_start_date date; --4878630
1322:
1323: --13359423
1324: l_yrly_tax_cred number;