DBA Data[Home] [Help]

APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on HR_GENERAL

Line 440: ,hr_general.decode_lookup('KR_JOB_TITLE',hsck.segment2) kr_job_title

436: CURSOR csr_additional_info(p_assignment_id NUMBER
437: ,p_run_effective_date DATE)
438: IS
439: SELECT paa.assignment_id
440: ,hr_general.decode_lookup('KR_JOB_TITLE',hsck.segment2) kr_job_title
441: ,hr_general.decode_lookup('KR_SENIORITY',hsck.segment3) kr_seniority
442: ,pkg.grade_name second_grade
443: ,pgp.grade_point_name grade_point
444: FROM hr_soft_coding_keyflex hsck

Line 441: ,hr_general.decode_lookup('KR_SENIORITY',hsck.segment3) kr_seniority

437: ,p_run_effective_date DATE)
438: IS
439: SELECT paa.assignment_id
440: ,hr_general.decode_lookup('KR_JOB_TITLE',hsck.segment2) kr_job_title
441: ,hr_general.decode_lookup('KR_SENIORITY',hsck.segment3) kr_seniority
442: ,pkg.grade_name second_grade
443: ,pgp.grade_point_name grade_point
444: FROM hr_soft_coding_keyflex hsck
445: ,per_assignments_f paa

Line 563: ,nvl(hr_general_utilities.get_lookup_Meaning('KR_BANK',substr(pai.action_information5,1,2)),' ') bank_name

559: CURSOR csr_net_pay(p_assignment_action_id IN NUMBER)
560: IS
561: SELECT pai.action_information_id
562: ,pai.action_information5
563: ,nvl(hr_general_utilities.get_lookup_Meaning('KR_BANK',substr(pai.action_information5,1,2)),' ') bank_name
564: FROM pay_action_information pai
565: WHERE action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
566: AND action_context_id = p_assignment_action_id
567: AND action_context_type = 'AAP';