APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 50: FROM hr_organization_units

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

Line 64: l_employer_name hr_organization_units.name%TYPE;

60: AND u.legislation_code = 'KW'
61: AND u.business_group_id is null
62: AND u.creator_type = 'B';
63:
64: l_employer_name hr_organization_units.name%TYPE;
65: l_employer_ssn NUMBER;
66: l_basic_si_base_id NUMBER;
67: l_supp_si_base_id NUMBER;
68: l_ee_basic_si_id NUMBER;

Line 730: FROM hr_organization_units

726:
727: /*Cursor for fetching Employer Name*/
728: CURSOR csr_employer_name IS
729: SELECT name
730: FROM hr_organization_units
731: WHERE organization_id = p_employer_id;
732:
733: /*Cursor for fetching defined balance id*/
734: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 791: l_employer_name hr_organization_units.name%TYPE;

787: TYPE asi_emp_rec_table IS TABLE OF asi_emp_rec INDEX BY BINARY_INTEGER;
788: t_asi_emp_rec asi_emp_rec_table;
789:
790:
791: l_employer_name hr_organization_units.name%TYPE;
792: l_employer_ssn NUMBER;
793: l_add_si_id NUMBER;
794: l_add_si_arr_id NUMBER;
795: l_add_si_val NUMBER;

Line 1139: FROM hr_organization_units

1135:
1136: /*Cursor for fetching Employer Name*/
1137: CURSOR csr_employer_name IS
1138: SELECT name
1139: FROM hr_organization_units
1140: WHERE organization_id = p_employer_id;
1141:
1142: /*Cursor for fetching defined balance id*/
1143: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

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

1231: /* Cursor for fetching Employer's Address */
1232: CURSOR csr_get_address IS
1233: SELECT address_line_1 || decode(address_line_2,null,null,',') || address_line_2 || decode(postal_code,null,null,',')|| postal_code
1234: FROM hr_locations hl
1235: , hr_organization_units hou /*hr_all_organization_units hou*/
1236: WHERE hl.location_id = hou.location_id
1237: AND hou.organization_id = p_employer_id;
1238:
1239: l_emp_address VARCHAR2(1000);

Line 1260: l_employer_name hr_organization_units.name%TYPE;

1256: TYPE asi_emp_rec_table IS TABLE OF asi_emp_rec INDEX BY BINARY_INTEGER;
1257: t_asi_emp_rec asi_emp_rec_table;
1258:
1259:
1260: l_employer_name hr_organization_units.name%TYPE;
1261: l_employer_ssn NUMBER;
1262: l_add_si_id NUMBER;
1263: l_add_si_arr_id NUMBER;
1264: l_add_si_val NUMBER;

Line 1780: FROM hr_organization_units

1776:
1777: /*Cursor for fetching Employer Name*/
1778: CURSOR csr_employer_name IS
1779: SELECT name
1780: FROM hr_organization_units
1781: WHERE organization_id = p_employer_id;
1782:
1783: /*Cursor for fetching defined balance id*/
1784: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 1965: l_employer_name hr_organization_units.name%TYPE;

1961: */
1962:
1963:
1964:
1965: l_employer_name hr_organization_units.name%TYPE;
1966: l_employer_ssn NUMBER;
1967: l_subject_si_id NUMBER;
1968: l_subject_si_val NUMBER;
1969: l_input_date VARCHAR2(30);