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.PAY_IN_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 1531: ,hr_organization_units hou

1527: SELECT hou.name
1528: FROM per_assignments_f peaf
1529: ,hr_soft_coding_keyflex hrscf
1530: ,hr_organization_information hoi
1531: ,hr_organization_units hou
1532: WHERE peaf.assignment_id=p_assignment_id
1533: AND peaf.soft_coding_keyflex_id=hrscf.soft_coding_keyflex_id
1534: AND hoi.organization_id=hrscf.segment1
1535: AND hoi.org_information_context='PER_IN_INCOME_TAX_DF'

Line 1568: l_reg_name hr_organization_units.name%TYPE;

1564:
1565: l_month VARCHAR2(30);
1566: l_year VARCHAR2(30);
1567: /* Bug 4159662*/
1568: l_reg_name hr_organization_units.name%TYPE;
1569: l_act_inf_id pay_action_information.action_information_id%TYPE;
1570: l_message VARCHAR2(255);
1571: l_full_name per_people_f.full_name%TYPE;
1572:

Line 1860: from hr_organization_units hoi

1856: -- Cursor to find PF Organization Id
1857: CURSOR c_pf_org_id(p_assignment_action_id NUMBER)
1858: IS
1859: select DISTINCT hoi.organization_id source_id
1860: from hr_organization_units hoi
1861: ,hr_soft_coding_keyflex scf
1862: ,per_assignments_f asg
1863: ,pay_assignment_actions paa
1864: where asg.assignment_id=paa.assignment_id

Line 1893: FROM hr_organization_units hou

1889: Cursor c_pf_name(p_organization_id NUMBER
1890: ,p_effective_date DATE)
1891: IS
1892: SELECT hou.name
1893: FROM hr_organization_units hou
1894: WHERE hou.organization_id=p_organization_id
1895: AND p_effective_date BETWEEN hou.date_from AND nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'));
1896:
1897: -- Bug 4033745 Start

Line 2004: l_source_id hr_organization_units.organization_id%TYPE;

2000: l_contr_period VARCHAR2(10);
2001: l_full_name per_people_f.full_name%TYPE;
2002: l_pf_number per_people_f.per_information8%TYPE;
2003: l_fh_hus per_people_f.full_name%TYPE;
2004: l_source_id hr_organization_units.organization_id%TYPE;
2005: l_pf_org_name hr_organization_units.name%TYPE;
2006: l_pension_num per_people_f.per_information13%TYPE;
2007: flag BOOLEAN;
2008: l_start_date DATE;

Line 2005: l_pf_org_name hr_organization_units.name%TYPE;

2001: l_full_name per_people_f.full_name%TYPE;
2002: l_pf_number per_people_f.per_information8%TYPE;
2003: l_fh_hus per_people_f.full_name%TYPE;
2004: l_source_id hr_organization_units.organization_id%TYPE;
2005: l_pf_org_name hr_organization_units.name%TYPE;
2006: l_pension_num per_people_f.per_information13%TYPE;
2007: flag BOOLEAN;
2008: l_start_date DATE;
2009: l_end_date DATE;

Line 2443: FROM hr_organization_units hoi

2439: -- Cursor to find ESI Organization Id
2440: CURSOR c_esi_org_id(p_assignment_action_id NUMBER)
2441: IS
2442: SELECT DISTINCT hoi.organization_id source_id
2443: FROM hr_organization_units hoi
2444: ,hr_soft_coding_keyflex scf
2445: ,per_assignments_f asg
2446: ,pay_assignment_actions paa
2447: WHERE asg.assignment_id=paa.assignment_id

Line 2544: FROM hr_organization_units hou

2540: Cursor c_esi_name(p_organization_id NUMBER
2541: ,p_effective_date DATE)
2542: IS
2543: SELECT hou.name
2544: FROM hr_organization_units hou
2545: WHERE hou.organization_id=p_organization_id
2546: AND p_effective_date BETWEEN hou.date_from AND nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'));
2547:
2548: --Cursor to find date of death

Line 2635: l_source_id hr_organization_units.organization_id%TYPE;

2631: l_contr_period VARCHAR2(30);
2632: l_full_name per_people_f.full_name%TYPE;
2633: l_person_id per_people_f.person_id%TYPE;
2634: l_esi_number per_people_f.per_information9%TYPE;
2635: l_source_id hr_organization_units.organization_id%TYPE;
2636: l_esi_org_name hr_organization_units.name%TYPE;
2637: flag BOOLEAN;
2638: l_reason_for_exem VARCHAR2(60);
2639: l_exempted_frm_esi VARCHAR2(5);

Line 2636: l_esi_org_name hr_organization_units.name%TYPE;

2632: l_full_name per_people_f.full_name%TYPE;
2633: l_person_id per_people_f.person_id%TYPE;
2634: l_esi_number per_people_f.per_information9%TYPE;
2635: l_source_id hr_organization_units.organization_id%TYPE;
2636: l_esi_org_name hr_organization_units.name%TYPE;
2637: flag BOOLEAN;
2638: l_reason_for_exem VARCHAR2(60);
2639: l_exempted_frm_esi VARCHAR2(5);
2640: l_temp VARCHAR2(5);

Line 3088: FROM hr_organization_units hou

3084: Cursor c_org_name(p_organization_id NUMBER
3085: ,p_effective_date DATE)
3086: IS
3087: SELECT hou.name
3088: FROM hr_organization_units hou
3089: WHERE hou.organization_id=p_organization_id
3090: AND p_effective_date BETWEEN hou.date_from AND nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'));
3091:
3092: --Cursor to find the Registered name, Code of the PF/ESI Organization , Classification and its address

Line 3109: ,hr_organization_units hou

3105: decode(hr_general.decode_lookup('IN_STATES',hla.loc_information16),null,null,','||hr_general.decode_lookup('IN_STATES',hla.loc_information16))||
3106: decode(hla.postal_code,null,null,','||hla.postal_code)
3107: ,1,240)
3108: FROM hr_organization_information hoi
3109: ,hr_organization_units hou
3110: ,hr_organization_units hou1
3111: ,hr_locations_all hla
3112: WHERE hoi.organization_id=p_organization_id
3113: AND hoi.org_information_context = DECODE(p_context,'PF','PER_IN_PF_DF','ESI','PER_IN_ESI_DF')

Line 3110: ,hr_organization_units hou1

3106: decode(hla.postal_code,null,null,','||hla.postal_code)
3107: ,1,240)
3108: FROM hr_organization_information hoi
3109: ,hr_organization_units hou
3110: ,hr_organization_units hou1
3111: ,hr_locations_all hla
3112: WHERE hoi.organization_id=p_organization_id
3113: AND hoi.org_information_context = DECODE(p_context,'PF','PER_IN_PF_DF','ESI','PER_IN_ESI_DF')
3114: AND hou.organization_id = DECODE (p_context,'PF',hoi.org_information8,'ESI',hoi.org_information2)

Line 3184: l_reg_name hr_organization_units.name%TYPE;

3180: AND action_information2 = p_organization_id
3181: AND action_context_type = 'PA';
3182:
3183: l_org_rep_name per_people_f.full_name%TYPE;
3184: l_reg_name hr_organization_units.name%TYPE;
3185: l_code hr_organization_information.org_information1%TYPE;
3186: l_org_name hr_organization_units.name%TYPE;
3187: l_address VARCHAR2(240);
3188: l_contr_period VARCHAR2(35);

Line 3186: l_org_name hr_organization_units.name%TYPE;

3182:
3183: l_org_rep_name per_people_f.full_name%TYPE;
3184: l_reg_name hr_organization_units.name%TYPE;
3185: l_code hr_organization_information.org_information1%TYPE;
3186: l_org_name hr_organization_units.name%TYPE;
3187: l_address VARCHAR2(240);
3188: l_contr_period VARCHAR2(35);
3189: l_class VARCHAR2(10);
3190: l_action_info_id NUMBER;

Line 3406: FROM hr_organization_units hoi

3402: -- Cursor to find PT Organization State
3403: CURSOR c_pt_state(p_assignment_action_id NUMBER)
3404: IS
3405: SELECT DISTINCT pay_in_prof_tax_pkg.get_state(hoi.organization_id) jurisdiction_code
3406: FROM hr_organization_units hoi
3407: ,hr_soft_coding_keyflex scf
3408: ,per_assignments_f asg
3409: ,pay_assignment_actions paa
3410: WHERE asg.assignment_id = paa.assignment_id

Line 3427: FROM hr_organization_units hoi

3423: ,name
3424: FROM ( */SELECT hoi.organization_id source_id
3425: ,hoi.name name
3426: ,asg.effective_end_date
3427: FROM hr_organization_units hoi
3428: ,hr_soft_coding_keyflex scf
3429: ,per_assignments_f asg
3430: ,pay_assignment_actions paa
3431: WHERE asg.assignment_id = paa.assignment_id

Line 3515: l_source_id hr_organization_units.organization_id%TYPE;

3511: l_start_date DATE;
3512: l_end_date DATE;
3513: l_full_name per_people_f.full_name%TYPE;
3514: l_person_id per_people_f.person_id%TYPE;
3515: l_source_id hr_organization_units.organization_id%TYPE;
3516: l_pt_org_name hr_organization_units.name%TYPE;
3517: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3518: l_state_iv_id pay_input_values_f.input_value_id%TYPE;
3519: l_reason_iv_id pay_input_values_f.input_value_id%TYPE;

Line 3516: l_pt_org_name hr_organization_units.name%TYPE;

3512: l_end_date DATE;
3513: l_full_name per_people_f.full_name%TYPE;
3514: l_person_id per_people_f.person_id%TYPE;
3515: l_source_id hr_organization_units.organization_id%TYPE;
3516: l_pt_org_name hr_organization_units.name%TYPE;
3517: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3518: l_state_iv_id pay_input_values_f.input_value_id%TYPE;
3519: l_reason_iv_id pay_input_values_f.input_value_id%TYPE;
3520: l_asg_id per_assignments_f.assignment_id%TYPE;

Line 3773: FROM hr_organization_units hou

3769: Cursor c_org_name(p_organization_id NUMBER
3770: ,p_effective_date DATE)
3771: IS
3772: SELECT hou.name
3773: FROM hr_organization_units hou
3774: WHERE hou.organization_id = p_organization_id
3775: AND p_effective_date BETWEEN hou.date_from AND NVL(date_to, TO_DATE('31-12-4712', 'DD-MM-YYYY'));
3776:
3777: --Cursor to find the Registered name, Code of the PF/ESI Organization , Classification and its address

Line 3795: ,hr_organization_units hou

3791: , null, null, ',' || hr_general.decode_lookup('IN_STATES', hla.loc_information16))||
3792: DECODE(hla.postal_code, null, null, ','||hla.postal_code)
3793: ,1,240)
3794: FROM hr_organization_information hoi
3795: ,hr_organization_units hou
3796: ,hr_organization_units hou1
3797: ,hr_locations_all hla
3798: WHERE hoi.organization_id = p_organization_id
3799: AND hoi.org_information_context = 'PER_IN_PROF_TAX_DF'

Line 3796: ,hr_organization_units hou1

3792: DECODE(hla.postal_code, null, null, ','||hla.postal_code)
3793: ,1,240)
3794: FROM hr_organization_information hoi
3795: ,hr_organization_units hou
3796: ,hr_organization_units hou1
3797: ,hr_locations_all hla
3798: WHERE hoi.organization_id = p_organization_id
3799: AND hoi.org_information_context = 'PER_IN_PROF_TAX_DF'
3800: AND hou.organization_id = hoi.org_information2

Line 3849: l_reg_name hr_organization_units.name%TYPE;

3845: l_contr_year VARCHAR2(10);
3846: l_rep_pos PER_ALL_POSITIONS.NAME%TYPE;
3847: l_act_inf_cat VARCHAR2(30);
3848: l_effective_date DATE;
3849: l_reg_name hr_organization_units.name%TYPE;
3850: l_reg_no hr_organization_information.org_information1%TYPE;
3851: l_org_name hr_organization_units.name%TYPE;
3852: l_org_rep_name per_people_f.full_name%TYPE;
3853: l_rep_person_id per_people_f.person_id%TYPE;

Line 3851: l_org_name hr_organization_units.name%TYPE;

3847: l_act_inf_cat VARCHAR2(30);
3848: l_effective_date DATE;
3849: l_reg_name hr_organization_units.name%TYPE;
3850: l_reg_no hr_organization_information.org_information1%TYPE;
3851: l_org_name hr_organization_units.name%TYPE;
3852: l_org_rep_name per_people_f.full_name%TYPE;
3853: l_rep_person_id per_people_f.person_id%TYPE;
3854: l_org_id hr_organization_units.organization_id%TYPE;
3855: l_source_id hr_organization_units.organization_id%TYPE;

Line 3854: l_org_id hr_organization_units.organization_id%TYPE;

3850: l_reg_no hr_organization_information.org_information1%TYPE;
3851: l_org_name hr_organization_units.name%TYPE;
3852: l_org_rep_name per_people_f.full_name%TYPE;
3853: l_rep_person_id per_people_f.person_id%TYPE;
3854: l_org_id hr_organization_units.organization_id%TYPE;
3855: l_source_id hr_organization_units.organization_id%TYPE;
3856: l_message VARCHAR2(255);
3857: l_procedure VARCHAR2(100);
3858:

Line 3855: l_source_id hr_organization_units.organization_id%TYPE;

3851: l_org_name hr_organization_units.name%TYPE;
3852: l_org_rep_name per_people_f.full_name%TYPE;
3853: l_rep_person_id per_people_f.person_id%TYPE;
3854: l_org_id hr_organization_units.organization_id%TYPE;
3855: l_source_id hr_organization_units.organization_id%TYPE;
3856: l_message VARCHAR2(255);
3857: l_procedure VARCHAR2(100);
3858:
3859: