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_GB_TAX_CREDIT_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 76: PROCEDURE Check_Start_date(p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,

72: END Get_Element_Link_Id;
73: --
74: --
75: --
76: PROCEDURE Check_Start_date(p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
77: p_element_entry_id in PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE,
78: p_start_date in DATE,
79: p_element_name in VARCHAR2 default 'Tax Credit',
80: p_message out nocopy VARCHAR2) is

Line 77: p_element_entry_id in PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE,

73: --
74: --
75: --
76: PROCEDURE Check_Start_date(p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
77: p_element_entry_id in PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE,
78: p_start_date in DATE,
79: p_element_name in VARCHAR2 default 'Tax Credit',
80: p_message out nocopy VARCHAR2) is
81: --

Line 95: pay_element_entries_f ent,

91: Select 'Y'
92: FROM pay_element_entry_values_f eev1,
93: pay_element_entry_values_f eev2,
94: pay_element_entry_values_f eev3,
95: pay_element_entries_f ent,
96: pay_input_values_f ipv1,
97: pay_input_values_f ipv2,
98: pay_input_values_f ipv3,
99: pay_element_links_f lnk,

Line 151: pay_element_entries_f ent,

147: ) is
148: Select 'Y'
149: FROM pay_element_entry_values_f eev1,
150: pay_element_entry_values_f eev2,
151: pay_element_entries_f ent,
152: pay_input_values_f ipv1,
153: pay_input_values_f ipv2,
154: pay_element_links_f lnk,
155: pay_element_types_f ele

Line 182: pay_element_entries_f ent,

178: Select 'Y'
179: FROM pay_element_entry_values_f eev1,
180: pay_element_entry_values_f eev2,
181: pay_element_entry_values_f eev3,
182: pay_element_entries_f ent,
183: pay_input_values_f ipv1,
184: pay_input_values_f ipv2,
185: pay_input_values_f ipv3,
186: pay_element_links_f lnk,

Line 219: pay_element_entries_f ent,

215: p_ele in VARCHAR2) is
216: Select 'Y'
217: FROM pay_element_entry_values_f eev1,
218: pay_element_entry_values_f eev2,
219: pay_element_entries_f ent,
220: pay_input_values_f ipv1,
221: pay_input_values_f ipv2,
222: pay_element_links_f lnk,
223: pay_element_types_f ele

Line 434: PROCEDURE Check_End_Or_Stop_Date(p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,

430: end if; -- Which element type, tax credit or student loan
431: --
432: END Check_Start_Date;
433:
434: PROCEDURE Check_End_Or_Stop_Date(p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
435: p_element_entry_id in PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE,
436: p_end_date in DATE,
437: p_start_date in DATE,
438: p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

Line 435: p_element_entry_id in PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE,

431: --
432: END Check_Start_Date;
433:
434: PROCEDURE Check_End_Or_Stop_Date(p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
435: p_element_entry_id in PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE,
436: p_end_date in DATE,
437: p_start_date in DATE,
438: p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
439: p_message out nocopy VARCHAR2) is

Line 451: pay_element_entries_f ent,

447: Select 'Y'
448: FROM pay_element_entry_values_f eev1,
449: pay_element_entry_values_f eev2,
450: pay_element_entry_values_f eev3,
451: pay_element_entries_f ent,
452: pay_input_values_f ipv1,
453: pay_input_values_f ipv2,
454: pay_input_values_f ipv3,
455: pay_element_links_f lnk,

Line 562: p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,

558:
559: PROCEDURE Check_Delete_Possible(
560: p_datetrack_mode in VARCHAR2,
561: p_effective_date in DATE,
562: p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
563: p_start_date in DATE,
564: p_end_date in DATE,
565: p_message out nocopy VARCHAR2) is
566:

Line 567: cursor c_purge_allowed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE) is

563: p_start_date in DATE,
564: p_end_date in DATE,
565: p_message out nocopy VARCHAR2) is
566:
567: cursor c_purge_allowed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE) is
568: select max(effective_date)
569: from pay_payroll_actions ppa,
570: pay_assignment_actions paa,
571: per_all_assignments_f asg

Line 579: cursor c_end_date_allowed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,

575: and asg.payroll_id = ppa.payroll_id
576: and ppa.action_type = 'R'
577: and ppa.action_status='C';
578:
579: cursor c_end_date_allowed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
580: p_date in DATE) is
581: select /*+ ORDERED
582: INDEX(ptp PER_TIME_PERIODS_PK) */ 'Y'
583: from per_all_assignments_f asg,

Line 639: p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,

635: End Check_Delete_Possible;
636:
637:
638: Procedure Check_Daily_Rate(
639: p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
640: p_start_date in DATE,
641: p_message out nocopy VARCHAR2
642: ) is
643:

Line 644: cursor c_processed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,

640: p_start_date in DATE,
641: p_message out nocopy VARCHAR2
642: ) is
643:
644: cursor c_processed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
645: p_date in DATE) is
646: select 'Y'
647: from pay_payroll_actions ppa,
648: per_all_assignments_f asg