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.

[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 1660: ,hr_organization_units hou

1656: SELECT hou.name
1657: FROM per_assignments_f peaf
1658: ,hr_soft_coding_keyflex hrscf
1659: ,hr_organization_information hoi
1660: ,hr_organization_units hou
1661: WHERE peaf.assignment_id=p_assignment_id
1662: AND peaf.soft_coding_keyflex_id=hrscf.soft_coding_keyflex_id
1663: AND hoi.organization_id=hrscf.segment1
1664: AND hoi.org_information_context='PER_IN_INCOME_TAX_DF'

Line 1697: l_reg_name hr_organization_units.name%TYPE;

1693:
1694: l_month VARCHAR2(30);
1695: l_year VARCHAR2(30);
1696: /* Bug 4159662*/
1697: l_reg_name hr_organization_units.name%TYPE;
1698: l_act_inf_id pay_action_information.action_information_id%TYPE;
1699: l_message VARCHAR2(255);
1700: l_full_name per_people_f.full_name%TYPE;
1701: l_email_address per_people_f.email_address%TYPE;

Line 2009: from hr_organization_units hoi

2005: -- Cursor to find PF Organization Id
2006: CURSOR c_pf_org_id(p_assignment_action_id NUMBER)
2007: IS
2008: select DISTINCT hoi.organization_id source_id
2009: from hr_organization_units hoi
2010: ,hr_soft_coding_keyflex scf
2011: ,per_assignments_f asg
2012: ,pay_assignment_actions paa
2013: where asg.assignment_id=paa.assignment_id

Line 2042: FROM hr_organization_units hou

2038: Cursor c_pf_name(p_organization_id NUMBER
2039: ,p_effective_date DATE)
2040: IS
2041: SELECT hou.name
2042: FROM hr_organization_units hou
2043: WHERE hou.organization_id=p_organization_id
2044: AND p_effective_date BETWEEN hou.date_from AND nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'));
2045:
2046: -- Bug 4033745 Start

Line 2175: l_source_id hr_organization_units.organization_id%TYPE;

2171: l_contr_period VARCHAR2(10);
2172: l_full_name per_people_f.full_name%TYPE;
2173: l_pf_number per_people_f.per_information8%TYPE;
2174: l_fh_hus per_people_f.full_name%TYPE;
2175: l_source_id hr_organization_units.organization_id%TYPE;
2176: l_pf_org_name hr_organization_units.name%TYPE;
2177: l_pension_num per_people_f.per_information13%TYPE;
2178: flag BOOLEAN;
2179: l_start_date DATE;

Line 2176: l_pf_org_name hr_organization_units.name%TYPE;

2172: l_full_name per_people_f.full_name%TYPE;
2173: l_pf_number per_people_f.per_information8%TYPE;
2174: l_fh_hus per_people_f.full_name%TYPE;
2175: l_source_id hr_organization_units.organization_id%TYPE;
2176: l_pf_org_name hr_organization_units.name%TYPE;
2177: l_pension_num per_people_f.per_information13%TYPE;
2178: flag BOOLEAN;
2179: l_start_date DATE;
2180: l_end_date DATE;

Line 2655: FROM hr_organization_units hoi

2651: -- Cursor to find ESI Organization Id
2652: CURSOR c_esi_org_id(p_assignment_action_id NUMBER)
2653: IS
2654: SELECT DISTINCT hoi.organization_id source_id
2655: FROM hr_organization_units hoi
2656: ,hr_soft_coding_keyflex scf
2657: ,per_assignments_f asg
2658: ,pay_assignment_actions paa
2659: WHERE asg.assignment_id=paa.assignment_id

Line 2756: FROM hr_organization_units hou

2752: Cursor c_esi_name(p_organization_id NUMBER
2753: ,p_effective_date DATE)
2754: IS
2755: SELECT hou.name
2756: FROM hr_organization_units hou
2757: WHERE hou.organization_id=p_organization_id
2758: AND p_effective_date BETWEEN hou.date_from AND nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'));
2759:
2760: --Cursor to find date of death

Line 2847: l_source_id hr_organization_units.organization_id%TYPE;

2843: l_contr_period VARCHAR2(30);
2844: l_full_name per_people_f.full_name%TYPE;
2845: l_person_id per_people_f.person_id%TYPE;
2846: l_esi_number per_people_f.per_information9%TYPE;
2847: l_source_id hr_organization_units.organization_id%TYPE;
2848: l_esi_org_name hr_organization_units.name%TYPE;
2849: flag BOOLEAN;
2850: l_reason_for_exem VARCHAR2(60);
2851: l_exempted_frm_esi VARCHAR2(5);

Line 2848: l_esi_org_name hr_organization_units.name%TYPE;

2844: l_full_name per_people_f.full_name%TYPE;
2845: l_person_id per_people_f.person_id%TYPE;
2846: l_esi_number per_people_f.per_information9%TYPE;
2847: l_source_id hr_organization_units.organization_id%TYPE;
2848: l_esi_org_name hr_organization_units.name%TYPE;
2849: flag BOOLEAN;
2850: l_reason_for_exem VARCHAR2(60);
2851: l_exempted_frm_esi VARCHAR2(5);
2852: l_temp VARCHAR2(5);

Line 3300: FROM hr_organization_units hou

3296: Cursor c_org_name(p_organization_id NUMBER
3297: ,p_effective_date DATE)
3298: IS
3299: SELECT hou.name
3300: FROM hr_organization_units hou
3301: WHERE hou.organization_id=p_organization_id
3302: AND p_effective_date BETWEEN hou.date_from AND nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'));
3303:
3304: --Cursor to find the Registered name, Code of the PF/ESI Organization , Classification and its address

Line 3321: ,hr_organization_units hou

3317: decode(hr_general.decode_lookup('IN_STATES',hla.loc_information16),null,null,','||hr_general.decode_lookup('IN_STATES',hla.loc_information16))||
3318: decode(hla.postal_code,null,null,','||hla.postal_code)
3319: ,1,240)
3320: FROM hr_organization_information hoi
3321: ,hr_organization_units hou
3322: ,hr_organization_units hou1
3323: ,hr_locations_all hla
3324: WHERE hoi.organization_id=p_organization_id
3325: AND hoi.org_information_context = DECODE(p_context,'PF','PER_IN_PF_DF','ESI','PER_IN_ESI_DF')

Line 3322: ,hr_organization_units hou1

3318: decode(hla.postal_code,null,null,','||hla.postal_code)
3319: ,1,240)
3320: FROM hr_organization_information hoi
3321: ,hr_organization_units hou
3322: ,hr_organization_units hou1
3323: ,hr_locations_all hla
3324: WHERE hoi.organization_id=p_organization_id
3325: AND hoi.org_information_context = DECODE(p_context,'PF','PER_IN_PF_DF','ESI','PER_IN_ESI_DF')
3326: AND hou.organization_id = DECODE (p_context,'PF',hoi.org_information8,'ESI',hoi.org_information2)

Line 3396: l_reg_name hr_organization_units.name%TYPE;

3392: AND action_information2 = p_organization_id
3393: AND action_context_type = 'PA';
3394:
3395: l_org_rep_name per_people_f.full_name%TYPE;
3396: l_reg_name hr_organization_units.name%TYPE;
3397: l_code hr_organization_information.org_information1%TYPE;
3398: l_org_name hr_organization_units.name%TYPE;
3399: l_address VARCHAR2(240);
3400: l_contr_period VARCHAR2(35);

Line 3398: l_org_name hr_organization_units.name%TYPE;

3394:
3395: l_org_rep_name per_people_f.full_name%TYPE;
3396: l_reg_name hr_organization_units.name%TYPE;
3397: l_code hr_organization_information.org_information1%TYPE;
3398: l_org_name hr_organization_units.name%TYPE;
3399: l_address VARCHAR2(240);
3400: l_contr_period VARCHAR2(35);
3401: l_class VARCHAR2(10);
3402: l_action_info_id NUMBER;

Line 3626: FROM hr_organization_units hoi

3622: -- Cursor to find PT Organization State
3623: CURSOR c_pt_state(p_assignment_action_id NUMBER)
3624: IS
3625: SELECT DISTINCT pay_in_prof_tax_pkg.get_state(hoi.organization_id) jurisdiction_code
3626: FROM hr_organization_units hoi
3627: ,hr_soft_coding_keyflex scf
3628: ,per_assignments_f asg
3629: ,pay_assignment_actions paa
3630: WHERE asg.assignment_id = paa.assignment_id

Line 3647: FROM hr_organization_units hoi

3643: ,name
3644: FROM ( */SELECT hoi.organization_id source_id
3645: ,hoi.name name
3646: ,asg.effective_end_date
3647: FROM hr_organization_units hoi
3648: ,hr_soft_coding_keyflex scf
3649: ,per_assignments_f asg
3650: ,pay_assignment_actions paa
3651: WHERE asg.assignment_id = paa.assignment_id

Line 3735: l_source_id hr_organization_units.organization_id%TYPE;

3731: l_start_date DATE;
3732: l_end_date DATE;
3733: l_full_name per_people_f.full_name%TYPE;
3734: l_person_id per_people_f.person_id%TYPE;
3735: l_source_id hr_organization_units.organization_id%TYPE;
3736: l_pt_org_name hr_organization_units.name%TYPE;
3737: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3738: l_state_iv_id pay_input_values_f.input_value_id%TYPE;
3739: l_reason_iv_id pay_input_values_f.input_value_id%TYPE;

Line 3736: l_pt_org_name hr_organization_units.name%TYPE;

3732: l_end_date DATE;
3733: l_full_name per_people_f.full_name%TYPE;
3734: l_person_id per_people_f.person_id%TYPE;
3735: l_source_id hr_organization_units.organization_id%TYPE;
3736: l_pt_org_name hr_organization_units.name%TYPE;
3737: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3738: l_state_iv_id pay_input_values_f.input_value_id%TYPE;
3739: l_reason_iv_id pay_input_values_f.input_value_id%TYPE;
3740: l_asg_id per_assignments_f.assignment_id%TYPE;

Line 3993: FROM hr_organization_units hou

3989: Cursor c_org_name(p_organization_id NUMBER
3990: ,p_effective_date DATE)
3991: IS
3992: SELECT hou.name
3993: FROM hr_organization_units hou
3994: WHERE hou.organization_id = p_organization_id
3995: AND p_effective_date BETWEEN hou.date_from AND NVL(date_to, TO_DATE('31-12-4712', 'DD-MM-YYYY'));
3996:
3997: --Cursor to find the Registered name, Code of the PF/ESI Organization , Classification and its address

Line 4015: ,hr_organization_units hou

4011: , null, null, ',' || hr_general.decode_lookup('IN_STATES', hla.loc_information16))||
4012: DECODE(hla.postal_code, null, null, ','||hla.postal_code)
4013: ,1,240)
4014: FROM hr_organization_information hoi
4015: ,hr_organization_units hou
4016: ,hr_organization_units hou1
4017: ,hr_locations_all hla
4018: WHERE hoi.organization_id = p_organization_id
4019: AND hoi.org_information_context = 'PER_IN_PROF_TAX_DF'

Line 4016: ,hr_organization_units hou1

4012: DECODE(hla.postal_code, null, null, ','||hla.postal_code)
4013: ,1,240)
4014: FROM hr_organization_information hoi
4015: ,hr_organization_units hou
4016: ,hr_organization_units hou1
4017: ,hr_locations_all hla
4018: WHERE hoi.organization_id = p_organization_id
4019: AND hoi.org_information_context = 'PER_IN_PROF_TAX_DF'
4020: AND hou.organization_id = hoi.org_information2

Line 4069: l_reg_name hr_organization_units.name%TYPE;

4065: l_contr_year VARCHAR2(10);
4066: l_rep_pos PER_ALL_POSITIONS.NAME%TYPE;
4067: l_act_inf_cat VARCHAR2(30);
4068: l_effective_date DATE;
4069: l_reg_name hr_organization_units.name%TYPE;
4070: l_reg_no hr_organization_information.org_information1%TYPE;
4071: l_org_name hr_organization_units.name%TYPE;
4072: l_org_rep_name per_people_f.full_name%TYPE;
4073: l_rep_person_id per_people_f.person_id%TYPE;

Line 4071: l_org_name hr_organization_units.name%TYPE;

4067: l_act_inf_cat VARCHAR2(30);
4068: l_effective_date DATE;
4069: l_reg_name hr_organization_units.name%TYPE;
4070: l_reg_no hr_organization_information.org_information1%TYPE;
4071: l_org_name hr_organization_units.name%TYPE;
4072: l_org_rep_name per_people_f.full_name%TYPE;
4073: l_rep_person_id per_people_f.person_id%TYPE;
4074: l_org_id hr_organization_units.organization_id%TYPE;
4075: l_source_id hr_organization_units.organization_id%TYPE;

Line 4074: l_org_id hr_organization_units.organization_id%TYPE;

4070: l_reg_no hr_organization_information.org_information1%TYPE;
4071: l_org_name hr_organization_units.name%TYPE;
4072: l_org_rep_name per_people_f.full_name%TYPE;
4073: l_rep_person_id per_people_f.person_id%TYPE;
4074: l_org_id hr_organization_units.organization_id%TYPE;
4075: l_source_id hr_organization_units.organization_id%TYPE;
4076: l_message VARCHAR2(255);
4077: l_procedure VARCHAR2(100);
4078:

Line 4075: l_source_id hr_organization_units.organization_id%TYPE;

4071: l_org_name hr_organization_units.name%TYPE;
4072: l_org_rep_name per_people_f.full_name%TYPE;
4073: l_rep_person_id per_people_f.person_id%TYPE;
4074: l_org_id hr_organization_units.organization_id%TYPE;
4075: l_source_id hr_organization_units.organization_id%TYPE;
4076: l_message VARCHAR2(255);
4077: l_procedure VARCHAR2(100);
4078:
4079: