APPS.PAY_GENERIC_UPGRADE dependencies on PAY_ELEMENT_TYPES_F

Line 439: pay_element_types_f pet,

435: if (l_upg_level = 'B') then
436: --
437: sqlstr := 'select distinct pet.element_type_id
438: from
439: pay_element_types_f pet,
440: pay_payroll_actions pa1
441: where pa1.payroll_action_id = :payroll_action_id
442: and pet.business_group_id = pa1.business_group_id
443: order by pet.element_type_id';

Line 449: pay_element_types_f pet,

445: elsif (l_upg_level = 'L') then
446: --
447: sqlstr := 'select distinct pet.element_type_id
448: from
449: pay_element_types_f pet,
450: pay_payroll_actions pa1,
451: per_business_groups_perf pbg1,
452: per_business_groups_perf pbg
453: where pa1.payroll_action_id = :payroll_action_id

Line 464: pay_element_types_f pet,

460: elsif (l_upg_level = 'G') then
461: --
462: sqlstr := 'select distinct pet.element_type_id
463: from
464: pay_element_types_f pet,
465: pay_payroll_actions pa1
466: where pa1.payroll_action_id = :payroll_action_id
467: order by pet.element_type_id';
468: --

Line 640: pay_element_types_f pet,

636: cp_endetid number
637: ) is
638: select distinct pet.element_type_id
639: from
640: pay_element_types_f pet,
641: pay_payroll_actions ppa
642: where ppa.payroll_action_id = cp_pactid
643: and ppa.business_group_id = pet.business_group_id
644: and pet.element_type_id between cp_stetid and cp_endetid;

Line 684: pay_element_types_f pet,

680: cp_endetid number
681: ) is
682: select distinct pet.element_type_id
683: from
684: pay_element_types_f pet,
685: pay_payroll_actions ppa,
686: per_business_groups_perf pbg,
687: per_business_groups_perf pbg1
688: where ppa.payroll_action_id = cp_pactid

Line 719: from pay_element_types_f pet

715: cp_stetid number,
716: cp_endetid number
717: ) is
718: select distinct pet.element_type_id
719: from pay_element_types_f pet
720: where pet.element_type_id between cp_stetid and cp_endetid;
721: --
722: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
723: l_upg_def_nm pay_upgrade_definitions.short_name%type;