APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on HR_GENERAL

Line 445: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category) accrual_category

441: CURSOR csr_leave_balance
442: IS
443: --
444: SELECT pap.accrual_plan_name accrual_plan_name
445: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category) accrual_category
446: ,pap.accrual_units_of_measure accrual_uom
447: ,ppa.payroll_id payroll_id
448: ,pap.business_group_id business_group_id
449: ,pap.accrual_plan_id accrual_plan_id

Line 1667: hr_general.decode_lookup('IN_BANK',l_bank_name)||','||

1663: ELSE
1664: --
1665:
1666: l_bank :=
1667: hr_general.decode_lookup('IN_BANK',l_bank_name)||','||
1668: hr_general.decode_lookup('IN_BANK_BRANCH',l_bank_branch);
1669: --
1670: END IF;
1671: pay_in_utils.set_location(g_debug,l_procedure, 70);

Line 1668: hr_general.decode_lookup('IN_BANK_BRANCH',l_bank_branch);

1664: --
1665:
1666: l_bank :=
1667: hr_general.decode_lookup('IN_BANK',l_bank_name)||','||
1668: hr_general.decode_lookup('IN_BANK_BRANCH',l_bank_branch);
1669: --
1670: END IF;
1671: pay_in_utils.set_location(g_debug,l_procedure, 70);
1672: l_ovn := 1;

Line 3105: decode(hr_general.decode_lookup('IN_STATES',hla.loc_information16),null,null,','||hr_general.decode_lookup('IN_STATES',hla.loc_information16))||

3101: decode(hla.address_line_2,null,null,','||hla.address_line_2)||
3102: decode(hla.address_line_3,null,null,','||hla.address_line_3)||
3103: decode(hla.loc_information14,null,null,','||hla.loc_information14)||
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

Line 3143: DECODE(hr_general.decode_lookup('IN_STATES',add_information15),NULL,NULL,','||hr_general.decode_lookup('IN_STATES',add_information15))||

3139: DECODE(address_line2,NULL,NULL,','||address_line2)||
3140: DECODE(address_line3,NULL,NULL,','||address_line3)||
3141: DECODE(add_information13,NULL,NULL,','||add_information13)||
3142: DECODE(add_information14,NULL,NULL,','||add_information14)||
3143: DECODE(hr_general.decode_lookup('IN_STATES',add_information15),NULL,NULL,','||hr_general.decode_lookup('IN_STATES',add_information15))||
3144: DECODE(postal_code,NULL,NULL,','||postal_code)
3145: ,1,240) address
3146: FROM per_addresses
3147: WHERE person_id=p_person_id

Line 3790: DECODE(hr_general.decode_lookup('IN_STATES', hla.loc_information16)

3786: DECODE(hla.address_line_2, null, null, ',' || hla.address_line_2)||
3787: DECODE(hla.address_line_3, null, null, ',' || hla.address_line_3)||
3788: DECODE(hla.loc_information14, null, null, ',' || hla.loc_information14)||
3789: DECODE(hla.loc_information15, null, null, ',' || hla.loc_information15)||
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

Line 3791: , null, null, ',' || hr_general.decode_lookup('IN_STATES', hla.loc_information16))||

3787: DECODE(hla.address_line_3, null, null, ',' || hla.address_line_3)||
3788: DECODE(hla.loc_information14, null, null, ',' || hla.loc_information14)||
3789: DECODE(hla.loc_information15, null, null, ',' || hla.loc_information15)||
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