DBA Data[Home] [Help]

APPS.PAY_CN_SOE dependencies on HR_GENERAL

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

503:
504: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
505: IS
506: SELECT pap.accrual_plan_name
507: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
508: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
509: ,ppa.payroll_id
510: ,pap.business_group_id
511: ,pap.accrual_plan_id

Line 508: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)

504: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
505: IS
506: SELECT pap.accrual_plan_name
507: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
508: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
509: ,ppa.payroll_id
510: ,pap.business_group_id
511: ,pap.accrual_plan_id
512: ,paa.assignment_id

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

533:
534: CURSOR csr_get_annual_leave_R12(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
535: IS
536: SELECT paptl.accrual_plan_name
537: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
538: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
539: ,ppa.payroll_id
540: ,pap.business_group_id
541: ,pap.accrual_plan_id

Line 538: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)

534: CURSOR csr_get_annual_leave_R12(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
535: IS
536: SELECT paptl.accrual_plan_name
537: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
538: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
539: ,ppa.payroll_id
540: ,pap.business_group_id
541: ,pap.accrual_plan_id
542: ,paa.assignment_id