APPS.PAY_FRR_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 508: from pay_element_types_f pet

504:
505: Cursor c_chk_element_type
506: is
507: select null
508: from pay_element_types_f pet
509: where pet.element_type_id = p_element_type_id
510: and p_effective_date between pet.effective_start_date
511: and pet.effective_end_date
512: and ((p_business_group_id is not null and

Line 747: l_spr_element_id pay_element_types_f.element_type_id%type;

743: ,p_input_value_id in number
744: ) is
745: --
746: l_proc varchar2(72) := g_package||'chk_result_rule_type';
747: l_spr_element_id pay_element_types_f.element_type_id%type;
748: --
749: Cursor c_element_dets(p_element_type_id number)
750: is
751: select pet.processing_type

Line 755: from pay_element_types_f pet

751: select pet.processing_type
752: ,pet.third_party_pay_only_flag
753: ,pet.processing_priority
754: ,pet.multiple_entries_allowed_flag
755: from pay_element_types_f pet
756: where pet.element_type_id = p_element_type_id
757: and p_effective_date between pet.effective_start_date
758: and pet.effective_end_date;
759: --