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.HR_H2PI_VALIDATE dependencies on HR_H2PI_UPLOAD

Line 24: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;

20:
21: CURSOR csr_pay_bg_and_gre IS
22: SELECT organization_id
23: FROM hr_h2pi_bg_and_gre_v
24: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
25:
26: CURSOR csr_hr_data_removed (p_organization_id NUMBER) IS
27: SELECT organization_id
28: FROM hr_h2pi_bg_and_gre_v bg

Line 29: WHERE bg.business_group_id = hr_h2pi_upload.g_to_business_group_Id

25:
26: CURSOR csr_hr_data_removed (p_organization_id NUMBER) IS
27: SELECT organization_id
28: FROM hr_h2pi_bg_and_gre_v bg
29: WHERE bg.business_group_id = hr_h2pi_upload.g_to_business_group_Id
30: AND bg.organization_id = p_organization_id
31: AND NOT EXISTS (SELECT 'X'
32: FROM hr_h2pi_id_mapping him,
33: hr_h2pi_bg_and_gre bg1

Line 42: WHERE bg.business_group_id = hr_h2pi_upload.g_to_business_group_id

38:
39: CURSOR csr_payroll_data_added(p_organization_id NUMBER) IS
40: SELECT organization_id
41: FROM hr_h2pi_bg_and_gre_v bg
42: WHERE bg.business_group_id = hr_h2pi_upload.g_to_business_group_id
43: AND bg.organization_id = p_organization_id
44: AND NOT EXISTS (SELECT 'X'
45: FROM hr_h2pi_id_mapping him
46: WHERE him.to_id = bg.organization_id

Line 49: hr_h2pi_upload.g_to_business_group_id);

45: FROM hr_h2pi_id_mapping him
46: WHERE him.to_id = bg.organization_id
47: AND him.table_name = 'HR_ALL_ORGANIZATION_UNITS'
48: AND him.to_business_group_id =
49: hr_h2pi_upload.g_to_business_group_id);
50:
51: l_ed_rec hr_h2pi_bg_and_gre_v%ROWTYPE;
52: l_organization_to_id hr_h2pi_bg_and_gre.organization_id%TYPe;
53: l_counter BINARY_INTEGER ;

Line 67: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;

63: BEGIN
64: SELECT method_of_generation_emp_num
65: INTO l_method_of_gen_emp_num
66: FROM per_business_groups
67: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
68: IF l_method_of_gen_emp_num <> 'M' THEN
69: hr_h2pi_error.data_error(p_from_id => p_from_client_id,
70: p_table_name => 'HR_H2PI_BG_AND_GRE',
71: p_message_level => 'FATAL',

Line 203: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;

199:
200: CURSOR csr_pay_pay_bases IS
201: SELECT pay_basis_id
202: FROM hr_h2pi_pay_bases_v
203: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
204:
205: CURSOR csr_hr_data_removed (p_pay_basis_id NUMBER) IS
206: SELECT pay_basis_id
207: FROM hr_h2pi_pay_bases_v pay

Line 208: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id

204:
205: CURSOR csr_hr_data_removed (p_pay_basis_id NUMBER) IS
206: SELECT pay_basis_id
207: FROM hr_h2pi_pay_bases_v pay
208: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id
209: AND pay.pay_basis_id = p_pay_basis_id
210: AND NOT EXISTS (SELECT 'X'
211: FROM hr_h2pi_id_mapping him,
212: hr_h2pi_pay_bases pay1

Line 221: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_id

217:
218: CURSOR csr_payroll_data_added(p_pay_basis_id NUMBER) IS
219: SELECT pay_basis_id
220: FROM hr_h2pi_pay_bases_v pay
221: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_id
222: AND pay.pay_basis_id = p_pay_basis_id
223: AND NOT EXISTS (SELECT 'X'
224: FROM hr_h2pi_id_mapping him
225: WHERE him.to_id = pay.pay_basis_id

Line 228: hr_h2pi_upload.g_to_business_group_id);

224: FROM hr_h2pi_id_mapping him
225: WHERE him.to_id = pay.pay_basis_id
226: AND him.table_name = 'PER_PAY_BASES'
227: AND him.to_business_group_id =
228: hr_h2pi_upload.g_to_business_group_id);
229:
230: l_ed_rec hr_h2pi_pay_bases_v%ROWTYPE;
231: l_pay_basis_to_id hr_h2pi_pay_bases.pay_basis_id%TYPe;
232: l_counter BINARY_INTEGER ;

Line 358: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;

354:
355: CURSOR csr_pay_payrolls IS
356: SELECT payroll_id
357: FROM hr_h2pi_payrolls_v
358: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
359:
360: CURSOR csr_hr_data_removed (p_payroll_id NUMBER) IS
361: SELECT payroll_id
362: FROM hr_h2pi_payrolls_v pay

Line 363: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id

359:
360: CURSOR csr_hr_data_removed (p_payroll_id NUMBER) IS
361: SELECT payroll_id
362: FROM hr_h2pi_payrolls_v pay
363: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id
364: AND pay.payroll_id = p_payroll_id
365: AND NOT EXISTS (SELECT 'X'
366: FROM hr_h2pi_id_mapping him,
367: hr_h2pi_payrolls pay1

Line 376: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_id

372:
373: CURSOR csr_payroll_data_added(p_payroll_id NUMBER) IS
374: SELECT payroll_id
375: FROM hr_h2pi_payrolls_v pay
376: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_id
377: AND pay.payroll_id = p_payroll_id
378: AND NOT EXISTS (SELECT 'X'
379: FROM hr_h2pi_id_mapping him
380: WHERE him.to_id = pay.payroll_id

Line 383: hr_h2pi_upload.g_to_business_group_id);

379: FROM hr_h2pi_id_mapping him
380: WHERE him.to_id = pay.payroll_id
381: AND him.table_name = 'PAY_ALL_PAYROLLS_F'
382: AND him.to_business_group_id =
383: hr_h2pi_upload.g_to_business_group_id);
384:
385: l_ed_rec hr_h2pi_payrolls_v%ROWTYPE;
386: l_payroll_to_id pay_all_payrolls_f.payroll_id%TYPe;
387: l_counter BINARY_INTEGER ;

Line 520: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;

516:
517: CURSOR csr_pay_element_type IS
518: SELECT element_type_id
519: FROM hr_h2pi_element_types_v
520: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
521:
522: CURSOR csr_hr_data_removed (p_element_type_id NUMBER) IS
523: SELECT element_type_id
524: FROM hr_h2pi_element_types_v ele

Line 525: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id

521:
522: CURSOR csr_hr_data_removed (p_element_type_id NUMBER) IS
523: SELECT element_type_id
524: FROM hr_h2pi_element_types_v ele
525: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
526: AND ele.element_type_id = p_element_type_id
527: AND NOT EXISTS (SELECT 'X'
528: FROM hr_h2pi_id_mapping him,
529: hr_h2pi_element_types ele1

Line 538: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id

534:
535: CURSOR csr_payroll_data_added(p_element_type_id NUMBER) IS
536: SELECT element_type_id
537: FROM hr_h2pi_element_types_v ele
538: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
539: AND ele.element_type_id = p_element_type_id
540: AND NOT EXISTS (SELECT 'X'
541: FROM hr_h2pi_id_mapping him
542: WHERE him.to_id = ele.element_type_id

Line 545: hr_h2pi_upload.g_to_business_group_id);

541: FROM hr_h2pi_id_mapping him
542: WHERE him.to_id = ele.element_type_id
543: AND him.table_name = 'PAY_ELEMENT_TYPES_F'
544: AND him.to_business_group_id =
545: hr_h2pi_upload.g_to_business_group_id);
546:
547: l_ed_rec hr_h2pi_element_types_v%ROWTYPE;
548: l_element_type_to_id hr_h2pi_element_types.element_type_id%TYPe;
549: l_counter BINARY_INTEGER ;

Line 678: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;

674:
675: CURSOR csr_pay_org_payment_method IS
676: SELECT org_payment_method_id
677: FROM hr_h2pi_org_payment_methods_v
678: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
679:
680: CURSOR csr_hr_data_removed (p_org_payment_method_id NUMBER) IS
681: SELECT org_payment_method_id
682: FROM hr_h2pi_org_payment_methods_v ele

Line 683: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id

679:
680: CURSOR csr_hr_data_removed (p_org_payment_method_id NUMBER) IS
681: SELECT org_payment_method_id
682: FROM hr_h2pi_org_payment_methods_v ele
683: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
684: AND ele.org_payment_method_id = p_org_payment_method_id
685: AND NOT EXISTS (SELECT 'X'
686: FROM hr_h2pi_id_mapping him,
687: hr_h2pi_org_payment_methods ele1

Line 696: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id

692:
693: CURSOR csr_payroll_data_added(p_org_payment_method_id NUMBER) IS
694: SELECT org_payment_method_id
695: FROM hr_h2pi_org_payment_methods_v ele
696: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
697: AND ele.org_payment_method_id = p_org_payment_method_id
698: AND NOT EXISTS (SELECT 'X'
699: FROM hr_h2pi_id_mapping him
700: WHERE him.to_id = ele.org_payment_method_id

Line 703: hr_h2pi_upload.g_to_business_group_id);

699: FROM hr_h2pi_id_mapping him
700: WHERE him.to_id = ele.org_payment_method_id
701: AND him.table_name = 'PAY_ORG_PAYMENT_METHODS_F'
702: AND him.to_business_group_id =
703: hr_h2pi_upload.g_to_business_group_id);
704:
705: l_ed_rec hr_h2pi_org_payment_methods_v%ROWTYPE;
706: l_org_payment_method_to_id
707: hr_h2pi_org_payment_methods.org_payment_method_id%TYPe;

Line 848: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;

844:
845: CURSOR csr_pay_element_link IS
846: SELECT element_link_id
847: FROM hr_h2pi_element_links_v
848: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
849:
850: CURSOR csr_hr_data_removed (p_element_link_id NUMBER) IS
851: SELECT element_link_id
852: FROM hr_h2pi_element_links_v ele

Line 853: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id

849:
850: CURSOR csr_hr_data_removed (p_element_link_id NUMBER) IS
851: SELECT element_link_id
852: FROM hr_h2pi_element_links_v ele
853: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
854: AND ele.element_link_id = p_element_link_id
855: AND NOT EXISTS (SELECT 'X'
856: FROM hr_h2pi_id_mapping him,
857: hr_h2pi_element_links ele1

Line 866: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id

862:
863: CURSOR csr_payroll_data_added(p_element_link_id NUMBER) IS
864: SELECT element_link_id
865: FROM hr_h2pi_element_links_v ele
866: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
867: AND ele.element_link_id = p_element_link_id
868: AND NOT EXISTS (SELECT 'X'
869: FROM hr_h2pi_id_mapping him
870: WHERE him.to_id = ele.element_link_id

Line 873: hr_h2pi_upload.g_to_business_group_id);

869: FROM hr_h2pi_id_mapping him
870: WHERE him.to_id = ele.element_link_id
871: AND him.table_name = 'PAY_ELEMENT_LINKS_F'
872: AND him.to_business_group_id =
873: hr_h2pi_upload.g_to_business_group_id);
874:
875: l_ed_rec hr_h2pi_element_links_v%ROWTYPE;
876: l_element_link_to_id hr_h2pi_element_links.element_link_id%TYPe;
877: l_counter BINARY_INTEGER ;

Line 1078: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id

1074:
1075: CURSOR csr_ed_city_tax IS
1076: SELECT jurisdiction_code jurisdiction_code
1077: FROM hr_h2pi_city_tax_rules_v
1078: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id
1079: UNION ALL
1080: SELECT screen_entry_value jurisdiction_code
1081: FROM hr_h2pi_element_entry_values_v eev,
1082: pay_input_values_f iv,

Line 1089: AND eev.business_group_id = hr_h2pi_upload.g_to_business_group_id;

1085: AND iv.element_type_id = et.element_type_id
1086: AND eev.input_value_id = iv.input_value_id
1087: AND et.element_name IN ('VERTEX','Workers Compensation')
1088: AND iv.name = 'Jurisdiction'
1089: AND eev.business_group_id = hr_h2pi_upload.g_to_business_group_id;
1090:
1091: CURSOR csr_ed_city_tax_comp(p_state_code VARCHAR2,
1092: p_county_code VARCHAR2,
1093: p_city_code VARCHAR2) IS