APPS.PAY_DYN_TRIGGERS dependencies on PAY_FUNCTIONAL_AREAS

Line 64: from pay_functional_areas pfa,

60: is
61: cursor get_trg is
62: select pte.short_name,
63: pte.event_id
64: from pay_functional_areas pfa,
65: pay_functional_triggers pft,
66: pay_trigger_events pte
67: where pte.event_id = pft.event_id
68: and pft.area_id = pfa.area_id

Line 108: from pay_functional_areas pfa,

104: procedure gen_functional_area(p_short_name varchar2)
105: is
106: cursor get_trg is
107: select distinct pte.short_name
108: from pay_functional_areas pfa,
109: pay_functional_triggers pft,
110: pay_trigger_events pte
111: where pte.event_id = pft.event_id
112: and pft.area_id = pfa.area_id

Line 620: Inserts/Updates the PAY_FUNCTIONAL_AREAS table.

616: /*
617: NAME
618: create_func_area
619: NOTES
620: Inserts/Updates the PAY_FUNCTIONAL_AREAS table.
621: */
622: procedure create_func_area (p_area_name varchar2,
623: p_description varchar2
624: )

Line 628: update pay_functional_areas

624: )
625: is
626: begin
627: --
628: update pay_functional_areas
629: set
630: description = p_description
631: where short_name = p_area_name;
632: --

Line 634: insert into pay_functional_areas

630: description = p_description
631: where short_name = p_area_name;
632: --
633: if (SQL%notfound) then
634: insert into pay_functional_areas
635: (
636: area_id,
637: short_name,
638: description

Line 641: pay_functional_areas_s.nextval,

637: short_name,
638: description
639: )
640: select
641: pay_functional_areas_s.nextval,
642: p_area_name,
643: p_description
644: from sys.dual;
645: --

Line 674: from pay_functional_areas

670: where short_name = p_short_name;
671: --
672: select area_id
673: into l_area_id
674: from pay_functional_areas
675: where short_name = p_area_name;
676: --
677: if(p_OWNER='SEED') then
678: hr_general2.init_fndload(800,1);

Line 771: from pay_functional_areas

767: is
768: --
769: cursor csr_sel_area_id(p_area_name varchar2) is
770: select area_id
771: from pay_functional_areas
772: where upper(short_name) = upper(p_area_name);
773:
774: cursor csr_sel_payroll_id(p_payroll_name varchar2) is
775: select payroll_id