APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_INPUT_VALUES_F

Line 479: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)

475: AND DECODE(c_result_rule_type, 'M', '999', pfrr.input_value_id) = DECODE(c_result_rule_type, 'M', '999', c_input_value_id);
476:
477: /* Fetches the input value id for seeded Retropay elements */
478:
479: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)
480: IS
481: SELECT DISTINCT pet.element_type_id, piv.input_value_id
482: FROM pay_input_values_f piv,
483: pay_element_types_f pet

Line 482: FROM pay_input_values_f piv,

478:
479: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)
480: IS
481: SELECT DISTINCT pet.element_type_id, piv.input_value_id
482: FROM pay_input_values_f piv,
483: pay_element_types_f pet
484: WHERE pet.element_name = c_element_name
485: AND pet.legislation_code = 'AU'
486: AND piv.element_type_id = pet.element_type_id

Line 756: FROM pay_input_values_f

752: CURSOR c_get_input_values
753: IS
754: SELECT name,
755: input_value_id
756: FROM pay_input_values_f
757: WHERE business_group_id = p_business_group_id
758: AND element_type_id = p_retro_element_id;
759:
760: /* Gets the balance feeds attached with the input value of retro element*/

Line 761: CURSOR c_get_balance_feeds(c_input_value_id pay_input_values_f.input_value_id%TYPE)

757: WHERE business_group_id = p_business_group_id
758: AND element_type_id = p_retro_element_id;
759:
760: /* Gets the balance feeds attached with the input value of retro element*/
761: CURSOR c_get_balance_feeds(c_input_value_id pay_input_values_f.input_value_id%TYPE)
762: IS
763: SELECT balance_type_id, scale
764: FROM pay_balance_feeds_f
765: WHERE input_value_id = c_input_value_id

Line 778: CURSOR c_get_input_value_id(c_name pay_input_values_f.name%type)

774: where balance_type_id = c_balance_type_id
775: and input_value_id = c_input_value_id;
776:
777: /* Gets the input value id of Element created by Upgrade Process*/
778: CURSOR c_get_input_value_id(c_name pay_input_values_f.name%type)
779: IS
780: SELECT input_value_id
781: FROM pay_input_values_f
782: WHERE NAME = c_name

Line 781: FROM pay_input_values_f

777: /* Gets the input value id of Element created by Upgrade Process*/
778: CURSOR c_get_input_value_id(c_name pay_input_values_f.name%type)
779: IS
780: SELECT input_value_id
781: FROM pay_input_values_f
782: WHERE NAME = c_name
783: AND element_type_id = p_element_type_id
784: AND business_group_id = p_business_group_id;
785:

Line 929: from pay_input_values_f

925: MAX_VALUE,
926: MIN_VALUE,
927: WARNING_OR_ERROR,
928: VALUE_SET_ID
929: from pay_input_values_f
930: where element_type_id = p_retro_element_id
931: and business_group_id = p_business_group_id;
932:
933: rec_input_values c_get_input_value_info%ROWTYPE;

Line 951: FROM pay_input_values_f piv

947:
948: CURSOR c_input_exists(c_input_value_name VARCHAR2)
949: IS
950: SELECT piv.input_value_id,effective_start_date,object_version_number
951: FROM pay_input_values_f piv
952: WHERE piv.element_type_id = p_element_type_id
953: AND piv.NAME = c_input_value_name
954: AND piv.business_group_id = p_business_group_id;
955:

Line 1730: pay_input_values_f pivf

1726: AND NOT EXISTS
1727: ( SELECT '1'
1728: FROM pay_balance_feeds_f pbf,
1729: pay_balance_types pbt,
1730: pay_input_values_f pivf
1731: WHERE pbt.balance_type_id = pbf.balance_type_id
1732: AND pbt.balance_name in ('Retro LT 12 Mths Curr Yr Amount',
1733: 'Retro LT 12 Mths Prev Yr Amount',
1734: 'Lump Sum E Payments',