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_TAX_VAL dependencies on PAY_IE_TAX_HEADER_INTERFACE

Line 141: , pay_ie_tax_header_interface thi

137: , per_all_people_f per
138: , pay_all_payrolls_f pay
139: --, pay_ie_paye_details_f ppd
140: , pay_ie_tax_body_interface tbi
141: , pay_ie_tax_header_interface thi
142: WHERE per.person_id = asg.person_id
143: AND per.national_identifier = tbi.pps_number
144: AND asg.business_group_id = hou.business_group_id
145: AND hou.organization_id = hoi.organization_id

Line 243: , pay_ie_tax_header_interface thi,

239: , per_all_people_f per
240: , pay_all_payrolls_f pay
241: --, pay_ie_paye_details_f ppd
242: , pay_ie_tax_body_interface tbi
243: , pay_ie_tax_header_interface thi,
244: per_periods_of_service pps
245: WHERE per.person_id = asg.person_id
246: AND per.national_identifier = tbi.pps_number
247: AND asg.business_group_id = hou.business_group_id

Line 287: , pay_ie_tax_header_interface thi

283: , per_all_people_f per
284: , pay_all_payrolls_f pay
285: --, pay_ie_paye_details_f ppd
286: , pay_ie_tax_body_interface tbi
287: , pay_ie_tax_header_interface thi
288: WHERE per.person_id = asg.person_id
289: AND asg.business_group_id = hou.business_group_id
290: AND hou.organization_id = hoi.organization_id
291: AND hoi.org_information_context = 'IE_EMPLOYER_INFO'

Line 1606: , p_tax_year IN pay_ie_tax_header_interface.tax_year%TYPE) IS

1602: PROCEDURE count_validation_new(
1603: errbuf OUT NOCOPY VARCHAR2
1604: , retcode OUT NOCOPY VARCHAR2
1605: , p_employer_number IN VARCHAR2
1606: , p_tax_year IN pay_ie_tax_header_interface.tax_year%TYPE) IS
1607:
1608: -- Cursor to get the total values form body
1609: CURSOR c_body
1610: IS

Line 1633: FROM PAY_IE_TAX_HEADER_INTERFACE phs

1629: ,SUM(NVL(PBS.AM_USC_YRLY_CUTOFF_2,0)) sum_USC_YRLY_CUTOFF_2
1630: ,SUM(NVL(PBS.AM_USC_YRLY_CUTOFF_3,0)) sum_USC_YRLY_CUTOFF_3
1631: ,SUM(NVL(PBS.AM_USC_YRLY_CUTOFF_4,0)) sum_USC_YRLY_CUTOFF_4
1632: --
1633: FROM PAY_IE_TAX_HEADER_INTERFACE phs
1634: , PAY_IE_TAX_BODY_INTERFACE pbs
1635: WHERE PHS.EMPLOYER_NUMBER = PBS.EMPLOYER_NUMBER
1636: AND PHS.TAX_YEAR = p_tax_year
1637: AND PBS.EMPLOYER_NUMBER = p_employer_number;

Line 1664: FROM PAY_IE_TAX_HEADER_INTERFACE phs

1660: ,NVL(PTS.TOT_YEARLY_USC_RATE_2,0) total_YEARLY_USC_RATE_2
1661: ,NVL(PTS.TOT_YEARLY_USC_RATE_3,0) total_YEARLY_USC_RATE_3
1662: ,NVL(PTS.TOT_YEARLY_USC_RATE_4,0) total_YEARLY_USC_RATE_4
1663: --
1664: FROM PAY_IE_TAX_HEADER_INTERFACE phs
1665: , PAY_IE_TAX_TRAILER_INTERFACE pts
1666: WHERE PTS.EMPLOYER_NUMBER = p_employer_number
1667: AND PHS.TAX_YEAR = p_tax_year;
1668:

Line 2150: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');

2146: l_error_stack := errbuf;
2147: l_error := SQLERRM;
2148: retcode := 2;
2149: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
2150: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
2151:
2152: INSERT INTO pay_ie_tax_error ( pps_number
2153: , employee_number
2154: , full_name

Line 2192: l_record_type pay_ie_tax_header_interface.record_type%type;

2188: e_invlid_tax_year exception;
2189: l_pkg varchar2(100) := 'PAY_IE_TAX_VAL.READ_TAX_FILE';
2190:
2191: --Header
2192: l_record_type pay_ie_tax_header_interface.record_type%type;
2193: l_tax_year pay_ie_tax_header_interface.tax_year%type;
2194: l_employer_number pay_ie_tax_header_interface.employer_number%type;
2195: l_employer_name pay_ie_tax_header_interface.employer_name%type;
2196: l_employer_unit_no pay_ie_tax_header_interface.employer_unit_no%type;

Line 2193: l_tax_year pay_ie_tax_header_interface.tax_year%type;

2189: l_pkg varchar2(100) := 'PAY_IE_TAX_VAL.READ_TAX_FILE';
2190:
2191: --Header
2192: l_record_type pay_ie_tax_header_interface.record_type%type;
2193: l_tax_year pay_ie_tax_header_interface.tax_year%type;
2194: l_employer_number pay_ie_tax_header_interface.employer_number%type;
2195: l_employer_name pay_ie_tax_header_interface.employer_name%type;
2196: l_employer_unit_no pay_ie_tax_header_interface.employer_unit_no%type;
2197: l_hc_date pay_ie_tax_header_interface.hc_date%type;

Line 2194: l_employer_number pay_ie_tax_header_interface.employer_number%type;

2190:
2191: --Header
2192: l_record_type pay_ie_tax_header_interface.record_type%type;
2193: l_tax_year pay_ie_tax_header_interface.tax_year%type;
2194: l_employer_number pay_ie_tax_header_interface.employer_number%type;
2195: l_employer_name pay_ie_tax_header_interface.employer_name%type;
2196: l_employer_unit_no pay_ie_tax_header_interface.employer_unit_no%type;
2197: l_hc_date pay_ie_tax_header_interface.hc_date%type;
2198: l_hc_label_year pay_ie_tax_header_interface.hc_label_year%type;

Line 2195: l_employer_name pay_ie_tax_header_interface.employer_name%type;

2191: --Header
2192: l_record_type pay_ie_tax_header_interface.record_type%type;
2193: l_tax_year pay_ie_tax_header_interface.tax_year%type;
2194: l_employer_number pay_ie_tax_header_interface.employer_number%type;
2195: l_employer_name pay_ie_tax_header_interface.employer_name%type;
2196: l_employer_unit_no pay_ie_tax_header_interface.employer_unit_no%type;
2197: l_hc_date pay_ie_tax_header_interface.hc_date%type;
2198: l_hc_label_year pay_ie_tax_header_interface.hc_label_year%type;
2199:

Line 2196: l_employer_unit_no pay_ie_tax_header_interface.employer_unit_no%type;

2192: l_record_type pay_ie_tax_header_interface.record_type%type;
2193: l_tax_year pay_ie_tax_header_interface.tax_year%type;
2194: l_employer_number pay_ie_tax_header_interface.employer_number%type;
2195: l_employer_name pay_ie_tax_header_interface.employer_name%type;
2196: l_employer_unit_no pay_ie_tax_header_interface.employer_unit_no%type;
2197: l_hc_date pay_ie_tax_header_interface.hc_date%type;
2198: l_hc_label_year pay_ie_tax_header_interface.hc_label_year%type;
2199:
2200: --Body

Line 2197: l_hc_date pay_ie_tax_header_interface.hc_date%type;

2193: l_tax_year pay_ie_tax_header_interface.tax_year%type;
2194: l_employer_number pay_ie_tax_header_interface.employer_number%type;
2195: l_employer_name pay_ie_tax_header_interface.employer_name%type;
2196: l_employer_unit_no pay_ie_tax_header_interface.employer_unit_no%type;
2197: l_hc_date pay_ie_tax_header_interface.hc_date%type;
2198: l_hc_label_year pay_ie_tax_header_interface.hc_label_year%type;
2199:
2200: --Body
2201: --l_record_type pay_ie_tax_body_interface.record_type%type;

Line 2198: l_hc_label_year pay_ie_tax_header_interface.hc_label_year%type;

2194: l_employer_number pay_ie_tax_header_interface.employer_number%type;
2195: l_employer_name pay_ie_tax_header_interface.employer_name%type;
2196: l_employer_unit_no pay_ie_tax_header_interface.employer_unit_no%type;
2197: l_hc_date pay_ie_tax_header_interface.hc_date%type;
2198: l_hc_label_year pay_ie_tax_header_interface.hc_label_year%type;
2199:
2200: --Body
2201: --l_record_type pay_ie_tax_body_interface.record_type%type;
2202: l_pps_number pay_ie_tax_body_interface.pps_number%type;

Line 2363: Delete from PAY_IE_TAX_HEADER_INTERFACE;

2359: End if;
2360:
2361:
2362: Begin
2363: Delete from PAY_IE_TAX_HEADER_INTERFACE;
2364: Delete from PAY_IE_TAX_BODY_INTERFACE;
2365: Delete from PAY_IE_TAX_TRAILER_INTERFACE;
2366: if sql%rowcount > 0 then
2367: commit;

Line 2426: INSERT INTO PAY_IE_TAX_HEADER_INTERFACE

2422: --fnd_file.PUT_LINE(FND_FILE.LOG, get_token(l_present_line,6));
2423: l_employer_unit_no:= substr(get_token(l_present_line,6),1,3);
2424: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_employer_unit_no:'||l_employer_unit_no);
2425:
2426: INSERT INTO PAY_IE_TAX_HEADER_INTERFACE
2427: (
2428: RECORD_TYPE
2429: ,EMPLOYER_NUMBER
2430: ,EMPLOYER_NAME

Line 3003: , p_tax_year IN pay_ie_tax_header_interface.tax_year%TYPE) IS

2999: PROCEDURE count_validation(
3000: errbuf OUT NOCOPY VARCHAR2
3001: , retcode OUT NOCOPY VARCHAR2
3002: , p_employer_number IN VARCHAR2
3003: , p_tax_year IN pay_ie_tax_header_interface.tax_year%TYPE) IS
3004:
3005: -- Cursor to get the total values form body
3006: CURSOR c_body
3007: IS

Line 3013: FROM PAY_IE_TAX_HEADER_INTERFACE phs

3009: , SUM (NVL(PBS.MTH_RATE_CUTOFF,0)) sum_mth_rate_cutoff
3010: , SUM (NVL(PBS.WK_RATE_CUTOFF,0)) sum_wk_rate_cutoff
3011: , SUM(NVL(PBS.MTH_TAX_CREDIT,0)) sum_mth_tax_credit
3012: , SUM(NVL(PBS.WK_TAX_CREDIT,0)) sum_wk_tax_credit
3013: FROM PAY_IE_TAX_HEADER_INTERFACE phs
3014: , PAY_IE_TAX_BODY_INTERFACE pbs
3015: WHERE PHS.EMPLOYER_NUMBER = PBS.EMPLOYER_NUMBER
3016: AND PHS.TAX_YEAR = p_tax_year
3017: AND PBS.EMPLOYER_NUMBER = p_employer_number;

Line 3027: FROM PAY_IE_TAX_HEADER_INTERFACE phs

3023: , NVL(PTS.TOTAL_MTH_RATE_CUTOFF,0) total_mth_cutoff
3024: , NVL(PTS.TOTAL_WK_RATE_CUTOFF,0) total_wk_cutoff
3025: , NVL(PTS.TOTAL_MTH_TAX_CREDIT,0) total_mth_credit
3026: , NVL(PTS.TOTAL_WK_TAX_CREDIT,0) total_wk_credit
3027: FROM PAY_IE_TAX_HEADER_INTERFACE phs
3028: , PAY_IE_TAX_TRAILER_INTERFACE pts
3029: WHERE PTS.EMPLOYER_NUMBER = p_employer_number
3030: AND PHS.TAX_YEAR = p_tax_year;
3031:

Line 3068: FROM PAY_IE_TAX_HEADER_INTERFACE);

3064:
3065: UPDATE PAY_IE_TAX_BODY_INTERFACE
3066: SET EMPLOYER_NUMBER =
3067: (SELECT EMPLOYER_NUMBER
3068: FROM PAY_IE_TAX_HEADER_INTERFACE);
3069:
3070: OPEN c_body;
3071:
3072: FETCH c_body into BodyRec;

Line 3217: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');

3213: l_error_stack := errbuf;
3214: l_error := SQLERRM;
3215: retcode := 2;
3216: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
3217: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
3218:
3219: INSERT INTO pay_ie_tax_error ( pps_number
3220: , employee_number
3221: , full_name

Line 3330: , pay_ie_tax_header_interface thi

3326: , per_all_people_f per
3327: , pay_all_payrolls_f pay
3328: --, pay_ie_paye_details_f ppd
3329: , pay_ie_tax_body_interface tbi
3330: , pay_ie_tax_header_interface thi
3331: WHERE per.person_id = asg.person_id
3332: AND per.national_identifier = tbi.pps_number
3333: AND asg.business_group_id = hou.business_group_id
3334: AND hou.organization_id = hoi.organization_id

Line 3396: , pay_ie_tax_header_interface thi,

3392: , per_all_people_f per
3393: , pay_all_payrolls_f pay
3394: --, pay_ie_paye_details_f ppd
3395: , pay_ie_tax_body_interface tbi
3396: , pay_ie_tax_header_interface thi,
3397: per_periods_of_service pps
3398: WHERE per.person_id = asg.person_id
3399: AND per.national_identifier = tbi.pps_number
3400: AND asg.business_group_id = hou.business_group_id

Line 3440: , pay_ie_tax_header_interface thi

3436: , per_all_people_f per
3437: , pay_all_payrolls_f pay
3438: --, pay_ie_paye_details_f ppd
3439: , pay_ie_tax_body_interface tbi
3440: , pay_ie_tax_header_interface thi
3441: WHERE per.person_id = asg.person_id
3442: AND asg.business_group_id = hou.business_group_id
3443: AND hou.organization_id = hoi.organization_id
3444: AND hoi.org_information_context = 'IE_EMPLOYER_INFO'