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 1222: l_tan hr_organization_information.org_information1%TYPE;

1218: l_next_year VARCHAR2(20);
1219: l_period NUMBER;
1220: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
1221: l_payroll_id NUMBER;
1222: l_tan hr_organization_information.org_information1%TYPE;
1223: TYPE r_balance_name_val IS RECORD(l_balance_name pay_balance_types.balance_name%type,
1224: l_balance_val NUMBER);
1225: TYPE t_balance IS TABLE OF r_balance_name_val INDEX BY PLS_INTEGER;
1226: l_bal_name_val t_balance;

Line 1464: ,hr_organization_information hoi

1460: IS
1461: --
1462: SELECT hoi.org_information1
1463: FROM hr_soft_coding_keyflex hsck
1464: ,hr_organization_information hoi
1465: ,per_assignments_f paaf
1466: ,pay_assignment_actions paa
1467: ,pay_payroll_actions ppa
1468: WHERE paa.assignment_action_id = p_assactid

Line 1530: ,hr_organization_information hoi

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

Line 1553: l_prof_tax_number hr_organization_information.org_information1%TYPE;

1549: l_bank VARCHAR2(310);
1550: l_account_number pay_external_accounts.segment1%TYPE;
1551: l_percentage pay_personal_payment_methods_f.percentage%TYPE;
1552: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;
1553: l_prof_tax_number hr_organization_information.org_information1%TYPE;
1554: /*4229709*/
1555: l_emp_det_act_info_id NUMBER;
1556: l_tax_area VARCHAR2(10);
1557: l_dob VARCHAR2(30);

Line 2612: hr_organization_information target

2608: CURSOR csr_emplr_class IS
2609: SELECT target.org_information3 FROM
2610: per_all_assignments_f assign,
2611: hr_soft_coding_keyflex scl,
2612: hr_organization_information target
2613: WHERE assign.assignment_id = p_assignment_id
2614: AND p_payroll_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
2615: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2616: AND scl.segment1 = target.organization_id

Line 2652: l_emplr_class hr_organization_information.org_information3%TYPE;

2648: l_esi_ceiling_value NUMBER ;
2649: l_esi_con_salary NUMBER ;
2650: l_hire_date DATE;
2651: l_disable_proof VARCHAR2(10);
2652: l_emplr_class hr_organization_information.org_information3%TYPE;
2653: l_global_value ff_globals_f.global_name%TYPE;
2654: l_dummy NUMBER;
2655:
2656: l_message VARCHAR2(255);

Line 3108: FROM hr_organization_information hoi

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

Line 3125: FROM hr_organization_information hoi

3121: ,p_effective_date DATE)
3122: IS
3123: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
3124: ,peap.person_id person_id
3125: FROM hr_organization_information hoi
3126: ,per_people_f peap
3127: WHERE hoi.ORGANIZATION_ID=p_pf_org_id
3128: AND hoi.ORG_INFORMATION_CONTEXT = DECODE (p_context,'PF','PER_IN_PF_REP_DF','ESI','PER_IN_ESI_REP_DF')
3129: AND peap.person_id=hoi.ORG_INFORMATION1

Line 3185: l_code hr_organization_information.org_information1%TYPE;

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

Line 3794: FROM hr_organization_information hoi

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

Line 3811: FROM hr_organization_information hoi

3807: ,p_effective_date DATE)
3808: IS
3809: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
3810: ,peap.person_id person_id
3811: FROM hr_organization_information hoi
3812: ,per_people_f peap
3813: WHERE hoi.organization_id = p_pf_org_id
3814: AND hoi.org_information_context = 'PER_IN_PROF_TAX_REP_DF'
3815: AND peap.person_id = hoi.org_information1

Line 3850: l_reg_no hr_organization_information.org_information1%TYPE;

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