APPS.PAY_DYN_TRIGGERS dependencies on PAY_DATED_TABLES

Line 140: l_dyt_type pay_dated_tables.dyn_trigger_type%TYPE;

136: l_event_id pay_trigger_events.event_id%TYPE;
137: l_trigger_name varchar2(50);
138: l_sql varchar2(32767);
139:
140: l_dyt_type pay_dated_tables.dyn_trigger_type%TYPE;
141: l_tab_id pay_dated_tables.dated_table_id%TYPE;
142: l_ok boolean;
143:
144: begin

Line 141: l_tab_id pay_dated_tables.dated_table_id%TYPE;

137: l_trigger_name varchar2(50);
138: l_sql varchar2(32767);
139:
140: l_dyt_type pay_dated_tables.dyn_trigger_type%TYPE;
141: l_tab_id pay_dated_tables.dated_table_id%TYPE;
142: l_ok boolean;
143:
144: begin
145: select pte.generated_flag,

Line 162: pay_dated_tables pdt

158: l_protected_flag,
159: l_dyt_type,
160: l_tab_id
161: from pay_trigger_events pte,
162: pay_dated_tables pdt
163: where pte.table_name = pdt.table_name(+)
164: and pte.short_name = p_short_name;
165: --
166: if (l_protected_flag <> 'Y') then

Line 575: from pay_dated_tables

571: -- Eg type in PI, PU, PD
572:
573: select dated_table_id
574: into l_usage_id
575: from pay_dated_tables
576: where table_name = p_short_name;
577:
578: END IF;
579: --

Line 858: from pay_dated_tables

854:
855: l_table_name varchar2(120);
856: cursor get_dt_name is
857: select table_name
858: from pay_dated_tables
859: where dated_table_id = p_dated_table_id;
860:
861: begin
862: open get_dt_name;