APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on HR_GENERAL

Line 239: ,hr_general.decode_lookup('LEAV_REAS'

235: ,to_char(ppf.date_of_birth,'dd-Mon-yyyy') dob
236: ,to_char(ppos.date_start,'dd-Mon-yyyy') doj
237: ,round((months_between(ppos.actual_termination_date
238: , ppf.date_of_birth))/12) age
239: ,hr_general.decode_lookup('LEAV_REAS'
240: ,ppos.leaving_reason) leaving_reason
241: ,to_char(ppos.actual_termination_date,'dd-Mon-yyyy') dol
242: ,trunc(months_between(ppos.actual_termination_date
243: , ppos.date_start)/12) || ' Years and '

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

920: CURSOR c_payment_details(p_employee_number VARCHAR2
921: ,p_bus_grp_id NUMBER
922: ,p_max_payment_asg_id NUMBER)
923: IS
924: SELECT hr_general.decode_lookup('IN_BANK',pea.segment3) bank
925: ,hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) branch
926: ,pea.segment1 account_number
927: ,ppt.payment_type_name payment_type
928: ,ppp.value amount

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

921: ,p_bus_grp_id NUMBER
922: ,p_max_payment_asg_id NUMBER)
923: IS
924: SELECT hr_general.decode_lookup('IN_BANK',pea.segment3) bank
925: ,hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) branch
926: ,pea.segment1 account_number
927: ,ppt.payment_type_name payment_type
928: ,ppp.value amount
929: ,ppa.effective_date payment_date

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

1381: --
1382: l_leave_encashed_flag := 1;
1383: IF c_rec_leave_encashment.description = 'Leave Type' THEN
1384: gXMLTable(l_count).Name := 'c_leave_type';
1385: gXMLTable(l_count).Value := hr_general.decode_lookup('ABSENCE_CATEGORY'
1386: ,(c_rec_leave_encashment.amount));
1387: --
1388: ELSIF c_rec_leave_encashment.description = 'Leave Balance Days' THEN
1389: gXMLTable(l_count).Name := 'c_balance_days';

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

1464: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1465: --
1466: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Reason' THEN
1467: gXMLTable(l_count).Name := 'c_forfeiture_reason';
1468: gXMLTable(l_count).Value := hr_general.decode_lookup('IN_GRATUITY_FORFEITURE_REASON',c_rec_gratuity_payment.amount);
1469: --
1470: ELSIF c_rec_gratuity_payment.description = 'Pay Value' THEN
1471: gXMLTable(l_count).Name := 'c_gratuity_amount';
1472: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id