DBA Data[Home] [Help]

APPS.PAY_WF_PKG dependencies on HR_GENERAL

Line 929: hr_general.decode_lookup('PQP_VARIANCE_TYPES',per.variance_type) ovt,

925:
926: Begin
927: -- Exception REports Information
928: select per.exception_report_name ,
929: hr_general.decode_lookup('PQP_VARIANCE_TYPES',per.variance_type) ovt,
930: to_char(per.VARIANCE_VALUE)
931: into lv_exc_rep_name,lv_orv_type,lv_orv_value
932: from pqp_exception_reports per
933: where legislation_code = 'US'

Line 949: hr_general.decode_lookup('PQP_VARIANCE_TYPES',perg.variance_type) ovt,

945: /*
946: Begin
947: -- Exception Group Information
948: select perg.exception_report_name ,
949: hr_general.decode_lookup('PQP_VARIANCE_TYPES',perg.variance_type) ovt,
950: to_char(VARIANCE_VALUE)
951: into lv_exc_grp_name,lv_grp_orv_type,lv_grp_orv_value
952: from pqp_exception_report_groups perg
953: where legislation_code = 'US'