APPS.PSP_GENERAL dependencies on PQP_CONFIGURATION_VALUES

Line 444: FROM pqp_configuration_values

440: AND ROWNUM <= (p_high_date + 1) - p_low_date;
441:
442: CURSOR workschedule_config_cur IS
443: SELECT pcv_information1 work_schedules
444: FROM pqp_configuration_values
445: WHERE pcv_information_category = 'PSP_ENABLE_WORK_SCHEDULES'
446: AND legislation_code IS NULL
447: AND NVL(business_group_id, l_business_group_id) = l_business_group_id;
448:

Line 1778: FROM pqp_configuration_values pcv

1774: FUNCTION get_act_dff_grouping_option (p_business_group_id IN NUMBER)
1775: RETURN VARCHAR2 IS
1776: CURSOR grouping_option_cur IS
1777: SELECT 1 hierarchy, PCV_INFORMATION1
1778: FROM pqp_configuration_values pcv
1779: WHERE pcv.business_group_id = p_business_group_id
1780: AND pcv_information_category = 'PSP_ACT_DFF_GROUPING'
1781: UNION ALL
1782: SELECT 2 hierarchy, PCV_INFORMATION1

Line 1783: FROM pqp_configuration_values pcv

1779: WHERE pcv.business_group_id = p_business_group_id
1780: AND pcv_information_category = 'PSP_ACT_DFF_GROUPING'
1781: UNION ALL
1782: SELECT 2 hierarchy, PCV_INFORMATION1
1783: FROM pqp_configuration_values pcv
1784: WHERE pcv.business_group_id IS NULL
1785: AND pcv_information_category = 'PSP_ACT_DFF_GROUPING'
1786: ORDER BY 1;
1787:

Line 1803: FROM pqp_configuration_values pcv

1799: FUNCTION get_enc_dff_grouping_option (p_business_group_id IN NUMBER)
1800: RETURN VARCHAR2 IS
1801: CURSOR grouping_option_cur IS
1802: SELECT 1 hierarchy, PCV_INFORMATION1
1803: FROM pqp_configuration_values pcv
1804: WHERE pcv.business_group_id = p_business_group_id
1805: AND pcv_information_category = 'PSP_ENC_DFF_GROUPING'
1806: UNION ALL
1807: SELECT 2 hierarchy, PCV_INFORMATION1

Line 1808: FROM pqp_configuration_values pcv

1804: WHERE pcv.business_group_id = p_business_group_id
1805: AND pcv_information_category = 'PSP_ENC_DFF_GROUPING'
1806: UNION ALL
1807: SELECT 2 hierarchy, PCV_INFORMATION1
1808: FROM pqp_configuration_values pcv
1809: WHERE pcv.business_group_id IS NULL
1810: AND pcv_information_category = 'PSP_ENC_DFF_GROUPING'
1811: ORDER BY 1;
1812:

Line 2705: from pqp_configuration_values

2701: p_pcv_information_category in varchar2,
2702: p_pcv_information1 in varchar2 default null) return varchar2 IS
2703: Cursor get_CONFIGURATION_OPTION_CSR IS
2704: select 1 hierarchy, PCV_INFORMATION1 , pcv_information2
2705: from pqp_configuration_values
2706: where PCV_INFORMATION_CATEGORY = p_PCV_INFORMATION_CATEGORY
2707: and BUSINESS_GROUP_ID = p_business_group_id
2708: and (p_pcv_information1 is null
2709: or p_pcv_information1 = pcv_information1)

Line 2712: from pqp_configuration_values

2708: and (p_pcv_information1 is null
2709: or p_pcv_information1 = pcv_information1)
2710: UNION ALL
2711: select 2 hierarchy, PCV_INFORMATION1 , pcv_information2
2712: from pqp_configuration_values
2713: where PCV_INFORMATION_CATEGORY = p_PCV_INFORMATION_CATEGORY
2714: and BUSINESS_GROUP_ID IS NULL
2715: and (p_pcv_information1 is null
2716: or p_pcv_information1 = pcv_information1)

Line 2745: from pqp_configuration_values

2741: p_exp_type_segment OUT NOCOPY varchar2) is
2742:
2743: Cursor get_GL_APTOE_MAPPING_CSR(p_business_group_id IN NUMBER) IS
2744: select 1 hierarchy, PCV_INFORMATION1,PCV_INFORMATION2,PCV_INFORMATION3,PCV_INFORMATION4,PCV_INFORMATION5
2745: from pqp_configuration_values
2746: where PCV_INFORMATION_CATEGORY = 'PSP_GL_PTAOE_MAPPING'
2747: and BUSINESS_GROUP_ID = p_business_group_id
2748: UNION ALL
2749: select 2 hierarchy, PCV_INFORMATION1,PCV_INFORMATION2,PCV_INFORMATION3,PCV_INFORMATION4,PCV_INFORMATION5

Line 2750: from pqp_configuration_values

2746: where PCV_INFORMATION_CATEGORY = 'PSP_GL_PTAOE_MAPPING'
2747: and BUSINESS_GROUP_ID = p_business_group_id
2748: UNION ALL
2749: select 2 hierarchy, PCV_INFORMATION1,PCV_INFORMATION2,PCV_INFORMATION3,PCV_INFORMATION4,PCV_INFORMATION5
2750: from pqp_configuration_values
2751: where PCV_INFORMATION_CATEGORY = 'PSP_GL_PTAOE_MAPPING'
2752: and BUSINESS_GROUP_ID is null
2753: ORDER BY 1;
2754: