DBA Data[Home] [Help]

APPS.PAY_PBF_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 804: pay_element_types_f elt,

800: CURSOR csr_initial_feed_exist IS
801: SELECT 1
802: FROM pay_balance_feeds_f blf,
803: pay_input_values_f inv,
804: pay_element_types_f elt,
805: pay_element_classifications ec
806: WHERE blf.balance_type_id = p_balance_type_id
807: AND blf.input_value_id = inv.input_value_id
808: AND inv.element_type_id = elt.element_type_id

Line 942: pay_element_types_f pet

938: CURSOR csr_currency_match IS
939: SELECT 1
940: FROM pay_balance_types pbt,
941: pay_input_values_f piv,
942: pay_element_types_f pet
943: WHERE pbt.balance_type_id = p_balance_type_id
944: AND piv.input_value_id = p_input_value_id
945: AND pet.element_type_id = piv.element_type_id
946: AND pbt.currency_code = pet.output_currency_code;

Line 1642: pay_element_types_f elt,

1638: --
1639: cursor csr_balance_init_flag is
1640: SELECT 1
1641: FROM pay_input_values_f inv,
1642: pay_element_types_f elt,
1643: pay_element_classifications ec
1644: WHERE inv.input_value_id = p_input_value_id
1645: AND inv.element_type_id = elt.element_type_id
1646: AND elt.classification_id = ec.classification_id