APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_TYPE_RULES

Line 586: from pay_element_type_rules petr

582: IS
583:
584: cursor c_element_set (cp_element_set_id in number) is
585: select petr.element_type_id
586: from pay_element_type_rules petr
587: where petr.element_set_id = cp_element_set_id
588: and petr.include_or_exclude = 'I'
589: union all
590: select pet1.element_type_id

Line 604: from pay_element_type_rules petr

600: -- and pet1.element_name not like '%Fees' /* Bug#12605384 */
601: and pet1.element_name not like '%Priority'
602: minus
603: select petr.element_type_id
604: from pay_element_type_rules petr
605: where petr.element_set_id = cp_element_set_id
606: and petr.include_or_exclude = 'E';
607:
608: ln_set_element_type_id NUMBER;

Line 785: from pay_element_type_rules petr

781: and (cp_element_set_id is null
782: or (cp_element_set_id is not null
783: and prr.element_type_id in
784: (select petr.element_type_id
785: from pay_element_type_rules petr
786: where petr.element_set_id = cp_element_set_id
787: and petr.include_or_exclude = 'I'
788: union all
789: select pet1.element_type_id

Line 797: from pay_element_type_rules petr

793: from pay_ele_classification_rules
794: where element_set_id = cp_element_set_id)
795: minus
796: select petr.element_type_id
797: from pay_element_type_rules petr
798: where petr.element_set_id = cp_element_set_id
799: and petr.include_or_exclude = 'E'
800: )
801: )

Line 831: from pay_element_type_rules petr

827: and (cp_element_set_id is null
828: or (cp_element_set_id is not null
829: and prr.element_type_id in
830: (select petr.element_type_id
831: from pay_element_type_rules petr
832: where petr.element_set_id = cp_element_set_id
833: and petr.include_or_exclude = 'I'
834: union all
835: select pet1.element_type_id

Line 843: from pay_element_type_rules petr

839: from pay_ele_classification_rules
840: where element_set_id = cp_element_set_id)
841: minus
842: select petr.element_type_id
843: from pay_element_type_rules petr
844: where petr.element_set_id = cp_element_set_id
845: and petr.include_or_exclude = 'E'
846: )
847: )

Line 932: from pay_element_type_rules petr,

928: ,cp_start_date in date
929: ,cp_end_date in date
930: ) is
931: select distinct nvl(pettl.reporting_name,pettl.element_name)
932: from pay_element_type_rules petr,
933: pay_element_types_f pet,
934: pay_element_types_f_tl pettl
935: where pet.element_type_id = petr.element_type_id
936: and petr.element_set_id = cp_ele_set_id

Line 963: from pay_element_type_rules petr,

959: and pet1.effective_start_date <= cp_end_date --bug # 5229191
960: and pet1.effective_end_date >= cp_start_date
961: minus
962: select distinct nvl(pettl.reporting_name,pettl.element_name)
963: from pay_element_type_rules petr,
964: pay_element_types_f_tl pettl
965: where pettl.element_type_id = petr.element_type_id
966: and petr.element_set_id = cp_ele_set_id
967: and petr.include_or_exclude = 'E'