DBA Data[Home] [Help]

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 755: l_spr_element_id pay_element_types_f.element_type_id%type;

751: ,p_input_value_id in number
752: ) is
753: --
754: l_proc varchar2(72) := g_package||'chk_result_rule_type';
755: l_spr_element_id pay_element_types_f.element_type_id%type;
756: --
757: Cursor c_element_dets(p_element_type_id number)
758: is
759: select pet.processing_type

Line 763: from pay_element_types_f pet

759: select pet.processing_type
760: ,pet.third_party_pay_only_flag
761: ,pet.processing_priority
762: ,pet.multiple_entries_allowed_flag
763: from pay_element_types_f pet
764: where pet.element_type_id = p_element_type_id
765: and p_effective_date between pet.effective_start_date
766: and pet.effective_end_date;
767: --