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_INFORMATION

Line 1323: l_tan hr_organization_information.org_information1%TYPE;

1319: l_next_year VARCHAR2(20);
1320: l_period NUMBER;
1321: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
1322: l_payroll_id NUMBER;
1323: l_tan hr_organization_information.org_information1%TYPE;
1324: TYPE r_balance_name_val IS RECORD(l_balance_name pay_balance_types.balance_name%type,
1325: l_balance_val NUMBER);
1326: TYPE t_balance IS TABLE OF r_balance_name_val INDEX BY PLS_INTEGER;
1327: l_bal_name_val t_balance;

Line 1593: ,hr_organization_information hoi

1589: IS
1590: --
1591: SELECT hoi.org_information1
1592: FROM hr_soft_coding_keyflex hsck
1593: ,hr_organization_information hoi
1594: ,per_assignments_f paaf
1595: ,pay_assignment_actions paa
1596: ,pay_payroll_actions ppa
1597: WHERE paa.assignment_action_id = p_assactid

Line 1659: ,hr_organization_information hoi

1655: IS
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

Line 1682: l_prof_tax_number hr_organization_information.org_information1%TYPE;

1678: l_bank VARCHAR2(310);
1679: l_account_number pay_external_accounts.segment1%TYPE;
1680: l_percentage pay_personal_payment_methods_f.percentage%TYPE;
1681: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;
1682: l_prof_tax_number hr_organization_information.org_information1%TYPE;
1683: /*4229709*/
1684: l_emp_det_act_info_id NUMBER;
1685: l_tax_area VARCHAR2(10);
1686: l_dob VARCHAR2(30);

Line 2824: hr_organization_information target

2820: CURSOR csr_emplr_class IS
2821: SELECT target.org_information3 FROM
2822: per_all_assignments_f assign,
2823: hr_soft_coding_keyflex scl,
2824: hr_organization_information target
2825: WHERE assign.assignment_id = p_assignment_id
2826: AND p_payroll_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
2827: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2828: AND scl.segment1 = target.organization_id

Line 2864: l_emplr_class hr_organization_information.org_information3%TYPE;

2860: l_esi_ceiling_value NUMBER ;
2861: l_esi_con_salary NUMBER ;
2862: l_hire_date DATE;
2863: l_disable_proof VARCHAR2(10);
2864: l_emplr_class hr_organization_information.org_information3%TYPE;
2865: l_global_value ff_globals_f.global_name%TYPE;
2866: l_dummy NUMBER;
2867:
2868: l_message VARCHAR2(255);

Line 3320: FROM hr_organization_information hoi

3316: decode(hla.loc_information15,null,null,','||hla.loc_information15)||
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

Line 3337: FROM hr_organization_information hoi

3333: ,p_effective_date DATE)
3334: IS
3335: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
3336: ,peap.person_id person_id
3337: FROM hr_organization_information hoi
3338: ,per_people_f peap
3339: WHERE hoi.ORGANIZATION_ID=p_pf_org_id
3340: AND hoi.ORG_INFORMATION_CONTEXT = DECODE (p_context,'PF','PER_IN_PF_REP_DF','ESI','PER_IN_ESI_REP_DF')
3341: AND peap.person_id=hoi.ORG_INFORMATION1

Line 3397: l_code hr_organization_information.org_information1%TYPE;

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);
3401: l_class VARCHAR2(10);

Line 4014: FROM hr_organization_information hoi

4010: DECODE(hr_general.decode_lookup('IN_STATES', hla.loc_information16)
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

Line 4031: FROM hr_organization_information hoi

4027: ,p_effective_date DATE)
4028: IS
4029: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
4030: ,peap.person_id person_id
4031: FROM hr_organization_information hoi
4032: ,per_people_f peap
4033: WHERE hoi.organization_id = p_pf_org_id
4034: AND hoi.org_information_context = 'PER_IN_PROF_TAX_REP_DF'
4035: AND peap.person_id = hoi.org_information1

Line 4070: l_reg_no hr_organization_information.org_information1%TYPE;

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;
4074: l_org_id hr_organization_units.organization_id%TYPE;