APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_TYPE_RULES

Line 577: from pay_element_type_rules petr

573: IS
574:
575: cursor c_element_set (cp_element_set_id in number) is
576: select petr.element_type_id
577: from pay_element_type_rules petr
578: where petr.element_set_id = cp_element_set_id
579: and petr.include_or_exclude = 'I'
580: union all
581: select pet1.element_type_id

Line 595: from pay_element_type_rules petr

591: and pet1.element_name not like '%Fees'
592: and pet1.element_name not like '%Priority'
593: minus
594: select petr.element_type_id
595: from pay_element_type_rules petr
596: where petr.element_set_id = cp_element_set_id
597: and petr.include_or_exclude = 'E';
598:
599: ln_set_element_type_id NUMBER;

Line 776: from pay_element_type_rules petr

772: and (cp_element_set_id is null
773: or (cp_element_set_id is not null
774: and prr.element_type_id in
775: (select petr.element_type_id
776: from pay_element_type_rules petr
777: where petr.element_set_id = cp_element_set_id
778: and petr.include_or_exclude = 'I'
779: union all
780: select pet1.element_type_id

Line 788: from pay_element_type_rules petr

784: from pay_ele_classification_rules
785: where element_set_id = cp_element_set_id)
786: minus
787: select petr.element_type_id
788: from pay_element_type_rules petr
789: where petr.element_set_id = cp_element_set_id
790: and petr.include_or_exclude = 'E'
791: )
792: )

Line 822: from pay_element_type_rules petr

818: and (cp_element_set_id is null
819: or (cp_element_set_id is not null
820: and prr.element_type_id in
821: (select petr.element_type_id
822: from pay_element_type_rules petr
823: where petr.element_set_id = cp_element_set_id
824: and petr.include_or_exclude = 'I'
825: union all
826: select pet1.element_type_id

Line 834: from pay_element_type_rules petr

830: from pay_ele_classification_rules
831: where element_set_id = cp_element_set_id)
832: minus
833: select petr.element_type_id
834: from pay_element_type_rules petr
835: where petr.element_set_id = cp_element_set_id
836: and petr.include_or_exclude = 'E'
837: )
838: )

Line 923: from pay_element_type_rules petr,

919: ,cp_start_date in date
920: ,cp_end_date in date
921: ) is
922: select distinct nvl(pettl.reporting_name,pettl.element_name)
923: from pay_element_type_rules petr,
924: pay_element_types_f pet,
925: pay_element_types_f_tl pettl
926: where pet.element_type_id = petr.element_type_id
927: and petr.element_set_id = cp_ele_set_id

Line 954: from pay_element_type_rules petr,

950: and pet1.effective_start_date <= cp_end_date --bug # 5229191
951: and pet1.effective_end_date >= cp_start_date
952: minus
953: select distinct nvl(pettl.reporting_name,pettl.element_name)
954: from pay_element_type_rules petr,
955: pay_element_types_f_tl pettl
956: where pettl.element_type_id = petr.element_type_id
957: and petr.element_set_id = cp_ele_set_id
958: and petr.include_or_exclude = 'E'