eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_EVENT_QUALIFIERS_API dependencies on PAY_EVENT_QUALIFIERS_F

Line 42: l_event_qualifier_id pay_event_qualifiers_f.event_qualifier_id%TYPE;

38: l_current number;
39: --
40: -- Declare OUT variables
41: --
42: l_event_qualifier_id pay_event_qualifiers_f.event_qualifier_id%TYPE;
43: l_object_version_number pay_event_qualifiers_f.object_version_number%TYPE;
44: l_effective_start_date pay_event_qualifiers_f.effective_start_date%TYPE;
45: l_effective_end_date pay_event_qualifiers_f.effective_end_date%TYPE;
46:

Line 43: l_object_version_number pay_event_qualifiers_f.object_version_number%TYPE;

39: --
40: -- Declare OUT variables
41: --
42: l_event_qualifier_id pay_event_qualifiers_f.event_qualifier_id%TYPE;
43: l_object_version_number pay_event_qualifiers_f.object_version_number%TYPE;
44: l_effective_start_date pay_event_qualifiers_f.effective_start_date%TYPE;
45: l_effective_end_date pay_event_qualifiers_f.effective_end_date%TYPE;
46:
47: cursor csr_valid_name is

Line 44: l_effective_start_date pay_event_qualifiers_f.effective_start_date%TYPE;

40: -- Declare OUT variables
41: --
42: l_event_qualifier_id pay_event_qualifiers_f.event_qualifier_id%TYPE;
43: l_object_version_number pay_event_qualifiers_f.object_version_number%TYPE;
44: l_effective_start_date pay_event_qualifiers_f.effective_start_date%TYPE;
45: l_effective_end_date pay_event_qualifiers_f.effective_end_date%TYPE;
46:
47: cursor csr_valid_name is
48: select event_qualifier_id

Line 45: l_effective_end_date pay_event_qualifiers_f.effective_end_date%TYPE;

41: --
42: l_event_qualifier_id pay_event_qualifiers_f.event_qualifier_id%TYPE;
43: l_object_version_number pay_event_qualifiers_f.object_version_number%TYPE;
44: l_effective_start_date pay_event_qualifiers_f.effective_start_date%TYPE;
45: l_effective_end_date pay_event_qualifiers_f.effective_end_date%TYPE;
46:
47: cursor csr_valid_name is
48: select event_qualifier_id
49: , effective_start_date

Line 52: from pay_event_qualifiers_f

48: select event_qualifier_id
49: , effective_start_date
50: , effective_end_date
51: , object_version_number
52: from pay_event_qualifiers_f
53: where dated_table_id = p_dated_table_id
54: and column_name = p_column_name
55: and qualifier_name = p_qualifier_name;
56:

Line 265: l_effective_start_date pay_event_qualifiers_f.effective_start_date%TYPE;

261: l_effective_date date;
262: --
263: -- Declare OUT variables
264: --
265: l_effective_start_date pay_event_qualifiers_f.effective_start_date%TYPE;
266: l_effective_end_date pay_event_qualifiers_f.effective_end_date%TYPE;
267: --
268: -- Declare IN OUT variable
269: --

Line 266: l_effective_end_date pay_event_qualifiers_f.effective_end_date%TYPE;

262: --
263: -- Declare OUT variables
264: --
265: l_effective_start_date pay_event_qualifiers_f.effective_start_date%TYPE;
266: l_effective_end_date pay_event_qualifiers_f.effective_end_date%TYPE;
267: --
268: -- Declare IN OUT variable
269: --
270: l_object_version_number pay_event_qualifiers_f.object_version_number%TYPE;

Line 270: l_object_version_number pay_event_qualifiers_f.object_version_number%TYPE;

266: l_effective_end_date pay_event_qualifiers_f.effective_end_date%TYPE;
267: --
268: -- Declare IN OUT variable
269: --
270: l_object_version_number pay_event_qualifiers_f.object_version_number%TYPE;
271: --
272: begin
273: hr_utility.set_location('Entering:'|| l_proc, 10);
274: --

Line 439: l_effective_start_date pay_event_qualifiers_f.effective_start_date%type;

435: l_effective_date date;
436: --
437: -- Declare OUT variables
438: --
439: l_effective_start_date pay_event_qualifiers_f.effective_start_date%type;
440: l_effective_end_date pay_event_qualifiers_f.effective_end_date%type;
441: l_validation_start_date date;
442: l_validation_end_date date;
443: l_object_version_number pay_event_qualifiers_f.object_version_number%type;

Line 440: l_effective_end_date pay_event_qualifiers_f.effective_end_date%type;

436: --
437: -- Declare OUT variables
438: --
439: l_effective_start_date pay_event_qualifiers_f.effective_start_date%type;
440: l_effective_end_date pay_event_qualifiers_f.effective_end_date%type;
441: l_validation_start_date date;
442: l_validation_end_date date;
443: l_object_version_number pay_event_qualifiers_f.object_version_number%type;
444: --

Line 443: l_object_version_number pay_event_qualifiers_f.object_version_number%type;

439: l_effective_start_date pay_event_qualifiers_f.effective_start_date%type;
440: l_effective_end_date pay_event_qualifiers_f.effective_end_date%type;
441: l_validation_start_date date;
442: l_validation_end_date date;
443: l_object_version_number pay_event_qualifiers_f.object_version_number%type;
444: --
445: begin
446: hr_utility.set_location('Entering:'|| l_proc, 5);
447: --