DBA Data[Home] [Help]

APPS.PAY_WF_PKG dependencies on PQP_EXCEPTION_REPORTS

Line 1200: from pqp_exception_reports per

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'
1202: and per.exception_report_id = p_exception_report_name;
1203:
1204: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);

Line 2930: from pqp_exception_reports per

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'
2932: and per.exception_report_id = p_exception_report_name;
2933:
2934: hr_utility.trace('lv_exc_rep_name = ' || lv_exc_rep_name);