APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_INPUT_VALUES_F

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

448: AND DECODE(c_result_rule_type, 'M', '999', pfrr.input_value_id) = DECODE(c_result_rule_type, 'M', '999', c_input_value_id);
449:
450: /* Fetches the input value id for seeded Retropay elements */
451:
452: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)
453: IS
454: SELECT DISTINCT pet.element_type_id, piv.input_value_id
455: FROM pay_input_values_f piv,
456: pay_element_types_f pet

Line 455: FROM pay_input_values_f piv,

451:
452: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)
453: IS
454: SELECT DISTINCT pet.element_type_id, piv.input_value_id
455: FROM pay_input_values_f piv,
456: pay_element_types_f pet
457: WHERE pet.element_name = c_element_name
458: AND pet.legislation_code = 'AU'
459: AND piv.element_type_id = pet.element_type_id

Line 609: FROM pay_input_values_f

605: CURSOR c_get_input_values
606: IS
607: SELECT name,
608: input_value_id
609: FROM pay_input_values_f
610: WHERE business_group_id = p_business_group_id
611: AND element_type_id = p_retro_element_id;
612:
613: /* Gets the balance feeds attached with the input value of retro element*/

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

610: WHERE business_group_id = p_business_group_id
611: AND element_type_id = p_retro_element_id;
612:
613: /* Gets the balance feeds attached with the input value of retro element*/
614: CURSOR c_get_balance_feeds(c_input_value_id pay_input_values_f.input_value_id%TYPE)
615: IS
616: SELECT balance_type_id, scale
617: FROM pay_balance_feeds_f
618: WHERE input_value_id = c_input_value_id

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

627: where balance_type_id = c_balance_type_id
628: and input_value_id = c_input_value_id;
629:
630: /* Gets the input value id of Element created by Upgrade Process*/
631: CURSOR c_get_input_value_id(c_name pay_input_values_f.name%type)
632: IS
633: SELECT input_value_id
634: FROM pay_input_values_f
635: WHERE NAME = c_name

Line 634: FROM pay_input_values_f

630: /* Gets the input value id of Element created by Upgrade Process*/
631: CURSOR c_get_input_value_id(c_name pay_input_values_f.name%type)
632: IS
633: SELECT input_value_id
634: FROM pay_input_values_f
635: WHERE NAME = c_name
636: AND element_type_id = p_element_type_id
637: AND business_group_id = p_business_group_id;
638:

Line 776: from pay_input_values_f

772: MAX_VALUE,
773: MIN_VALUE,
774: WARNING_OR_ERROR,
775: VALUE_SET_ID
776: from pay_input_values_f
777: where element_type_id = p_retro_element_id
778: and business_group_id = p_business_group_id;
779:
780: rec_input_values c_get_input_value_info%ROWTYPE;

Line 798: FROM pay_input_values_f piv

794:
795: CURSOR c_input_exists(c_input_value_name VARCHAR2)
796: IS
797: SELECT piv.input_value_id,effective_start_date,object_version_number
798: FROM pay_input_values_f piv
799: WHERE piv.element_type_id = p_element_type_id
800: AND piv.NAME = c_input_value_name
801: AND piv.business_group_id = p_business_group_id;
802:

Line 1527: pay_input_values_f pivf

1523: AND NOT EXISTS
1524: ( SELECT '1'
1525: FROM pay_balance_feeds_f pbf,
1526: pay_balance_types pbt,
1527: pay_input_values_f pivf
1528: WHERE pbt.balance_type_id = pbf.balance_type_id
1529: AND pbt.balance_name in ('Retro LT 12 Mths Curr Yr Amount',
1530: 'Retro LT 12 Mths Prev Yr Amount',
1531: 'Lump Sum E Payments')