APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on HR_GENERAL

Line 327: ,hr_general.decode_lookup('LEAV_REAS'

323: ,to_char(ppf.date_of_birth,'dd-Mon-yyyy') dob
324: ,to_char(ppos.date_start,'dd-Mon-yyyy') doj
325: ,round((months_between(ppos.actual_termination_date
326: , ppf.date_of_birth))/12) age
327: ,hr_general.decode_lookup('LEAV_REAS'
328: ,ppos.leaving_reason) leaving_reason
329: ,to_char(ppos.actual_termination_date,'dd-Mon-yyyy') dol
330: ,trunc(months_between(ppos.actual_termination_date
331: , ppos.date_start)/12) || ' Years and '

Line 1021: SELECT hr_general.decode_lookup('IN_BANK',pea.segment3) bank

1017: CURSOR c_payment_details(p_employee_number VARCHAR2
1018: ,p_bus_grp_id NUMBER
1019: ,p_max_payment_asg_id NUMBER)
1020: IS
1021: SELECT hr_general.decode_lookup('IN_BANK',pea.segment3) bank
1022: ,hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) branch
1023: ,pea.segment1 account_number
1024: ,ppt.payment_type_name payment_type
1025: ,ppp.value amount

Line 1022: ,hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) branch

1018: ,p_bus_grp_id NUMBER
1019: ,p_max_payment_asg_id NUMBER)
1020: IS
1021: SELECT hr_general.decode_lookup('IN_BANK',pea.segment3) bank
1022: ,hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) branch
1023: ,pea.segment1 account_number
1024: ,ppt.payment_type_name payment_type
1025: ,ppp.value amount
1026: ,ppa.effective_date payment_date

Line 1509: gXMLTable(l_count).Value := hr_general.decode_lookup('ABSENCE_CATEGORY'

1505: --
1506: l_leave_encashed_flag := 1;
1507: IF c_rec_leave_encashment.description = 'Leave Type' THEN
1508: gXMLTable(l_count).Name := 'c_leave_type';
1509: gXMLTable(l_count).Value := hr_general.decode_lookup('ABSENCE_CATEGORY'
1510: ,(c_rec_leave_encashment.amount));
1511: --
1512: ELSIF c_rec_leave_encashment.description = 'Leave Balance Days' THEN
1513: gXMLTable(l_count).Name := 'c_balance_days';

Line 1592: gXMLTable(l_count).Value := hr_general.decode_lookup('IN_GRATUITY_FORFEITURE_REASON',c_rec_gratuity_payment.amount);

1588: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1589: --
1590: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Reason' THEN
1591: gXMLTable(l_count).Name := 'c_forfeiture_reason';
1592: gXMLTable(l_count).Value := hr_general.decode_lookup('IN_GRATUITY_FORFEITURE_REASON',c_rec_gratuity_payment.amount);
1593: --
1594: ELSIF c_rec_gratuity_payment.description = 'Pay Value' THEN
1595: gXMLTable(l_count).Name := 'c_gratuity_amount';
1596: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id