DBA Data[Home] [Help]

APPS.PAY_PBF_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 826: pay_element_types_f elt,

822: CURSOR csr_initial_feed_exist IS
823: SELECT 1
824: FROM pay_balance_feeds_f blf,
825: pay_input_values_f inv,
826: pay_element_types_f elt,
827: pay_element_classifications ec
828: WHERE blf.balance_type_id = p_balance_type_id
829: AND blf.input_value_id = inv.input_value_id
830: AND inv.element_type_id = elt.element_type_id

Line 964: pay_element_types_f pet

960: CURSOR csr_currency_match IS
961: SELECT 1
962: FROM pay_balance_types pbt,
963: pay_input_values_f piv,
964: pay_element_types_f pet
965: WHERE pbt.balance_type_id = p_balance_type_id
966: AND piv.input_value_id = p_input_value_id
967: AND pet.element_type_id = piv.element_type_id
968: AND pbt.currency_code = pet.output_currency_code;

Line 1685: pay_element_types_f elt,

1681: --
1682: cursor csr_balance_init_flag is
1683: SELECT 1
1684: FROM pay_input_values_f inv,
1685: pay_element_types_f elt,
1686: pay_element_classifications ec
1687: WHERE inv.input_value_id = p_input_value_id
1688: AND inv.element_type_id = elt.element_type_id
1689: AND elt.classification_id = ec.classification_id