APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 46: FROM hr_organization_units

42:
43: /*Cursor for fetching Employer Name*/
44: CURSOR csr_employer_name IS
45: SELECT name
46: FROM hr_organization_units
47: WHERE organization_id = p_employer_id;
48:
49: /*Cursor for fetching defined balance id*/
50: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 60: l_employer_name hr_organization_units.name%TYPE;

56: AND u.legislation_code = 'KW'
57: AND u.business_group_id is null
58: AND u.creator_type = 'B';
59:
60: l_employer_name hr_organization_units.name%TYPE;
61: l_employer_ssn NUMBER;
62: l_basic_si_base_id NUMBER;
63: l_supp_si_base_id NUMBER;
64: l_ee_basic_si_id NUMBER;

Line 579: FROM hr_organization_units

575:
576: /*Cursor for fetching Employer Name*/
577: CURSOR csr_employer_name IS
578: SELECT name
579: FROM hr_organization_units
580: WHERE organization_id = p_employer_id;
581:
582: /*Cursor for fetching defined balance id*/
583: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 640: l_employer_name hr_organization_units.name%TYPE;

636: TYPE asi_emp_rec_table IS TABLE OF asi_emp_rec INDEX BY BINARY_INTEGER;
637: t_asi_emp_rec asi_emp_rec_table;
638:
639:
640: l_employer_name hr_organization_units.name%TYPE;
641: l_employer_ssn NUMBER;
642: l_add_si_id NUMBER;
643: l_add_si_arr_id NUMBER;
644: l_add_si_val NUMBER;

Line 988: FROM hr_organization_units

984:
985: /*Cursor for fetching Employer Name*/
986: CURSOR csr_employer_name IS
987: SELECT name
988: FROM hr_organization_units
989: WHERE organization_id = p_employer_id;
990:
991: /*Cursor for fetching defined balance id*/
992: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 1084: , hr_organization_units hou /*hr_all_organization_units hou*/

1080: /* Cursor for fetching Employer's Address */
1081: CURSOR csr_get_address IS
1082: SELECT address_line_1 || decode(address_line_2,null,null,',') || address_line_2 || decode(postal_code,null,null,',')|| postal_code
1083: FROM hr_locations hl
1084: , hr_organization_units hou /*hr_all_organization_units hou*/
1085: WHERE hl.location_id = hou.location_id
1086: AND hou.organization_id = p_employer_id;
1087:
1088: l_emp_address VARCHAR2(1000);

Line 1109: l_employer_name hr_organization_units.name%TYPE;

1105: TYPE asi_emp_rec_table IS TABLE OF asi_emp_rec INDEX BY BINARY_INTEGER;
1106: t_asi_emp_rec asi_emp_rec_table;
1107:
1108:
1109: l_employer_name hr_organization_units.name%TYPE;
1110: l_employer_ssn NUMBER;
1111: l_add_si_id NUMBER;
1112: l_add_si_arr_id NUMBER;
1113: l_add_si_val NUMBER;

Line 1622: FROM hr_organization_units

1618:
1619: /*Cursor for fetching Employer Name*/
1620: CURSOR csr_employer_name IS
1621: SELECT name
1622: FROM hr_organization_units
1623: WHERE organization_id = p_employer_id;
1624:
1625: /*Cursor for fetching defined balance id*/
1626: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 1759: l_employer_name hr_organization_units.name%TYPE;

1755: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1756: rec_get_emp_name csr_get_emp_name%ROWTYPE;
1757:
1758:
1759: l_employer_name hr_organization_units.name%TYPE;
1760: l_employer_ssn NUMBER;
1761: l_subject_si_id NUMBER;
1762: l_subject_si_val NUMBER;
1763: l_input_date VARCHAR2(30);