APPS.PQP_UTILITIES dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 1331: pay_element_type_extra_info WHERE

1327:
1328: OPEN c_value FOR ' SELECT '
1329: || l_col_name
1330: || ' FROM
1331: pay_element_type_extra_info WHERE
1332: information_type ='
1333: || ''''
1334: || p_flex_context
1335: || ''''

Line 1387: pay_element_type_extra_info.element_type_extra_info_id%TYPE ;

1383: l_rowcount NUMBER;
1384: l_error_code fnd_new_messages.message_number%TYPE;
1385:
1386: l_element_type_extra_info_id
1387: pay_element_type_extra_info.element_type_extra_info_id%TYPE ;
1388:
1389: CURSOR csr_get_extra_info_id
1390: (p_element_type_id NUMBER
1391: ,p_information_type VARCHAR2

Line 1394: FROM pay_element_type_extra_info

1390: (p_element_type_id NUMBER
1391: ,p_information_type VARCHAR2
1392: ) IS
1393: SELECT element_type_extra_info_id
1394: FROM pay_element_type_extra_info
1395: WHERE element_type_id = p_element_type_id
1396: AND information_type = p_information_type;
1397:
1398: l_proc_name VARCHAR2(61)

Line 1565: ,p_tab_name => 'PAY_ELEMENT_TYPE_EXTRA_INFO'

1561: , --p_information_type,
1562: p_flex_field_title => p_segment_name
1563: ,p_key_col => 'ELEMENT_TYPE_ID'
1564: ,p_key_val => p_element_type_id
1565: ,p_tab_name => 'PAY_ELEMENT_TYPE_EXTRA_INFO'
1566: ,p_effective_date => NULL
1567: ,p_eff_date_req => 'N'
1568: ,p_business_group_id => NULL
1569: ,p_bus_group_id_req => 'N'

Line 3123: FROM pay_element_type_extra_info pei

3119: -- for the element Type_id passed
3120: CURSOR csr_get_ele_type_extra_info_id
3121: IS
3122: SELECT pei.element_type_extra_info_id
3123: FROM pay_element_type_extra_info pei
3124: WHERE pei.information_type = p_information_type
3125: AND pei.element_type_id = p_element_type_id;
3126:
3127:

Line 3128: l_element_type_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;

3124: WHERE pei.information_type = p_information_type
3125: AND pei.element_type_id = p_element_type_id;
3126:
3127:
3128: l_element_type_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;
3129: l_retval NUMBER := 0 ;
3130: l_proc_name VARCHAR2(61)
3131: := g_package_name || 'pqp_get_ele_type_extra_info_id';
3132: