APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on HR_GENERAL

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

511: CURSOR csr_leave_balance
512: IS
513: --
514: SELECT pap.accrual_plan_name accrual_plan_name
515: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category) accrual_category
516: ,pap.accrual_units_of_measure accrual_uom
517: ,ppa.payroll_id payroll_id
518: ,pap.business_group_id business_group_id
519: ,pap.accrual_plan_id accrual_plan_id

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

1793: ELSE
1794: --
1795:
1796: l_bank :=
1797: hr_general.decode_lookup('IN_BANK',l_bank_name)||','||
1798: hr_general.decode_lookup('IN_BANK_BRANCH',l_bank_branch);
1799: --
1800: END IF;
1801: pay_in_utils.set_location(g_debug,l_procedure, 70);

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

1794: --
1795:
1796: l_bank :=
1797: hr_general.decode_lookup('IN_BANK',l_bank_name)||','||
1798: hr_general.decode_lookup('IN_BANK_BRANCH',l_bank_branch);
1799: --
1800: END IF;
1801: pay_in_utils.set_location(g_debug,l_procedure, 70);
1802: l_ovn := 1;

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

3313: decode(hla.address_line_2,null,null,','||hla.address_line_2)||
3314: decode(hla.address_line_3,null,null,','||hla.address_line_3)||
3315: decode(hla.loc_information14,null,null,','||hla.loc_information14)||
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

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

3351: DECODE(address_line2,NULL,NULL,','||address_line2)||
3352: DECODE(address_line3,NULL,NULL,','||address_line3)||
3353: DECODE(add_information13,NULL,NULL,','||add_information13)||
3354: DECODE(add_information14,NULL,NULL,','||add_information14)||
3355: DECODE(hr_general.decode_lookup('IN_STATES',add_information15),NULL,NULL,','||hr_general.decode_lookup('IN_STATES',add_information15))||
3356: DECODE(postal_code,NULL,NULL,','||postal_code)
3357: ,1,240) address
3358: FROM per_addresses
3359: WHERE person_id=p_person_id

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

4006: DECODE(hla.address_line_2, null, null, ',' || hla.address_line_2)||
4007: DECODE(hla.address_line_3, null, null, ',' || hla.address_line_3)||
4008: DECODE(hla.loc_information14, null, null, ',' || hla.loc_information14)||
4009: DECODE(hla.loc_information15, null, null, ',' || hla.loc_information15)||
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

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

4007: DECODE(hla.address_line_3, null, null, ',' || hla.address_line_3)||
4008: DECODE(hla.loc_information14, null, null, ',' || hla.loc_information14)||
4009: DECODE(hla.loc_information15, null, null, ',' || hla.loc_information15)||
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