APPS.PSP_PAYTRN dependencies on PQP_CONFIGURATION_VALUES

Line 422: FROM pqp_configuration_values pcv

418: -- Introduced the following for bug fix 2916848
419: /*
420: CURSOR proration_option_cur IS
421: SELECT pcv_information1
422: FROM pqp_configuration_values pcv
423: WHERE pcv.business_group_id = l_resp_business_group_id
424: AND pcv_information_category = 'PSP_PRORATION';
425: */
426:

Line 432: --l_proration_option pqp_configuration_values.pcv_information1%TYPE;

428: SELECT legislation_code
429: FROM per_business_groups
430: WHERE business_group_id = l_resp_business_group_id;
431:
432: --l_proration_option pqp_configuration_values.pcv_information1%TYPE;
433: l_legislation_code per_business_groups.legislation_code%TYPE;
434: l_exchange_rate_type psp_payroll_controls.exchange_rate_type%TYPE;
435: l_prev_currency_code psp_payroll_controls.currency_code%TYPE;
436:

Line 522: FROM pqp_configuration_values

518: WHERE element_entry_id = g_pay_costs_rec.source_id;
519:
520: CURSOR emphours_config_cur IS
521: SELECT DECODE(pcv_information1, 'Y', 'H', 'M') employee_hours
522: FROM pqp_configuration_values
523: WHERE pcv_information_category = 'PSP_IMPORT_EMPLOYEE_HOURS'
524: AND legislation_code IS NULL
525: AND NVL(business_group_id, p_business_group_id) = p_business_group_id;
526:

Line 534: FROM pqp_configuration_values

530: pcv_information3,
531: pcv_information4,
532: pcv_information5,
533: pcv_information6
534: FROM pqp_configuration_values
535: WHERE pcv_information_category = 'PSP_ELEMENT_ENTRY_CI_MAPPING'
536: AND legislation_code IS NULL
537: AND NVL(business_group_id, p_business_group_id) = p_business_group_id;
538:

Line 546: FROM pqp_configuration_values

542: value */
543:
544: CURSOR ignore_date_earned_cur IS
545: SELECT nvl(pcv_information1,'Y') --6779790
546: FROM pqp_configuration_values
547: WHERE pcv_information_category = 'PSP_USE_DATE_EARNED'
548: AND legislation_code IS NULL
549: AND NVL(business_group_id, p_business_group_id) = p_business_group_id; -- Bug 6046087
550: