APPS.PAY_WF_PKG dependencies on HR_GENERAL

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

1193:
1194: Begin
1195: -- Exception REports Information
1196: select per.exception_report_name ,
1197: hr_general.decode_lookup('PQP_VARIANCE_TYPES',per.variance_type) ovt,
1198: to_char(per.VARIANCE_VALUE)
1199: into lv_exc_rep_name,lv_orv_type,lv_orv_value
1200: from pqp_exception_reports per
1201: where legislation_code = 'US'

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

1213: /*
1214: Begin
1215: -- Exception Group Information
1216: select perg.exception_report_name ,
1217: hr_general.decode_lookup('PQP_VARIANCE_TYPES',perg.variance_type) ovt,
1218: to_char(VARIANCE_VALUE)
1219: into lv_exc_grp_name,lv_grp_orv_type,lv_grp_orv_value
1220: from pqp_exception_report_groups perg
1221: where legislation_code = 'US'

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

2923:
2924: Begin
2925: -- Exception REports Information
2926: select per.exception_report_name ,
2927: hr_general.decode_lookup('PQP_VARIANCE_TYPES',per.variance_type) ovt,
2928: to_char(per.VARIANCE_VALUE)
2929: into lv_exc_rep_name,lv_orv_type,lv_orv_value
2930: from pqp_exception_reports per
2931: where legislation_code = 'US'

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

2943: /*
2944: Begin
2945: -- Exception Group Information
2946: select perg.exception_report_name ,
2947: hr_general.decode_lookup('PQP_VARIANCE_TYPES',perg.variance_type) ovt,
2948: to_char(VARIANCE_VALUE)
2949: into lv_exc_grp_name,lv_grp_orv_type,lv_grp_orv_value
2950: from pqp_exception_report_groups perg
2951: where legislation_code = 'US'