APPS.PAY_IE_TAX_VAL dependencies on PAY_IE_TAX_HEADER_INTERFACE

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

31: PROCEDURE count_validation(
32: errbuf OUT NOCOPY VARCHAR2
33: , retcode OUT NOCOPY VARCHAR2
34: , p_employer_number IN VARCHAR2
35: , p_tax_year IN pay_ie_tax_header_interface.tax_year%TYPE) IS
36:
37: -- Cursor to get the total values form body
38: CURSOR c_body
39: IS

Line 45: FROM PAY_IE_TAX_HEADER_INTERFACE phs

41: , SUM (NVL(PBS.MTH_RATE_CUTOFF,0)) sum_mth_rate_cutoff
42: , SUM (NVL(PBS.WK_RATE_CUTOFF,0)) sum_wk_rate_cutoff
43: , SUM(NVL(PBS.MTH_TAX_CREDIT,0)) sum_mth_tax_credit
44: , SUM(NVL(PBS.WK_TAX_CREDIT,0)) sum_wk_tax_credit
45: FROM PAY_IE_TAX_HEADER_INTERFACE phs
46: , PAY_IE_TAX_BODY_INTERFACE pbs
47: WHERE PHS.EMPLOYER_NUMBER = PBS.EMPLOYER_NUMBER
48: AND PHS.TAX_YEAR = p_tax_year
49: AND PBS.EMPLOYER_NUMBER = p_employer_number;

Line 59: FROM PAY_IE_TAX_HEADER_INTERFACE phs

55: , NVL(PTS.TOTAL_MTH_RATE_CUTOFF,0) total_mth_cutoff
56: , NVL(PTS.TOTAL_WK_RATE_CUTOFF,0) total_wk_cutoff
57: , NVL(PTS.TOTAL_MTH_TAX_CREDIT,0) total_mth_credit
58: , NVL(PTS.TOTAL_WK_TAX_CREDIT,0) total_wk_credit
59: FROM PAY_IE_TAX_HEADER_INTERFACE phs
60: , PAY_IE_TAX_TRAILER_INTERFACE pts
61: WHERE PTS.EMPLOYER_NUMBER = p_employer_number
62: AND PHS.TAX_YEAR = p_tax_year;
63:

Line 100: FROM PAY_IE_TAX_HEADER_INTERFACE);

96:
97: UPDATE PAY_IE_TAX_BODY_INTERFACE
98: SET EMPLOYER_NUMBER =
99: (SELECT EMPLOYER_NUMBER
100: FROM PAY_IE_TAX_HEADER_INTERFACE);
101:
102: OPEN c_body;
103:
104: FETCH c_body into BodyRec;

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

245: l_error_stack := errbuf;
246: l_error := SQLERRM;
247: retcode := 2;
248: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
249: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
250:
251: INSERT INTO pay_ie_tax_error ( pps_number
252: , employee_number
253: , full_name

Line 362: , pay_ie_tax_header_interface thi

358: , per_all_people_f per
359: , pay_all_payrolls_f pay
360: --, pay_ie_paye_details_f ppd
361: , pay_ie_tax_body_interface tbi
362: , pay_ie_tax_header_interface thi
363: WHERE per.person_id = asg.person_id
364: AND per.national_identifier = tbi.pps_number
365: AND asg.business_group_id = hou.business_group_id
366: AND hou.organization_id = hoi.organization_id

Line 428: , pay_ie_tax_header_interface thi,

424: , per_all_people_f per
425: , pay_all_payrolls_f pay
426: --, pay_ie_paye_details_f ppd
427: , pay_ie_tax_body_interface tbi
428: , pay_ie_tax_header_interface thi,
429: per_periods_of_service pps
430: WHERE per.person_id = asg.person_id
431: AND per.national_identifier = tbi.pps_number
432: AND asg.business_group_id = hou.business_group_id

Line 472: , pay_ie_tax_header_interface thi

468: , per_all_people_f per
469: , pay_all_payrolls_f pay
470: --, pay_ie_paye_details_f ppd
471: , pay_ie_tax_body_interface tbi
472: , pay_ie_tax_header_interface thi
473: WHERE per.person_id = asg.person_id
474: AND asg.business_group_id = hou.business_group_id
475: AND hou.organization_id = hoi.organization_id
476: AND hoi.org_information_context = 'IE_EMPLOYER_INFO'