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_SE_WAGES_SALARIES dependencies on FND_DATE

Line 152: ,FND_DATE.canonical_to_date((get_parameter

148: (legislative_parameters
149: , 'YEAR'
150: )
151: ) L_YEAR
152: ,FND_DATE.canonical_to_date((get_parameter
153: (legislative_parameters
154: , 'RETROACTIVE_PAYMENT_FROM'
155: )
156: )) L_RETROACTIVE_PAYMENT_FROM

Line 157: ,FND_DATE.canonical_to_date((get_parameter

153: (legislative_parameters
154: , 'RETROACTIVE_PAYMENT_FROM'
155: )
156: )) L_RETROACTIVE_PAYMENT_FROM
157: ,FND_DATE.canonical_to_date((get_parameter
158: (legislative_parameters
159: , 'RETROACTIVE_PAYMENT_TO'
160: )
161: )) L_RETROACTIVE_PAYMENT_TO

Line 424: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,

420: ORDER BY paaf.assignment_id;
421:
422: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
423: is
424: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
425: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
426: FROM per_all_assignments_f asg1
427: ,per_all_assignments_f asg2
428: ,per_all_people_f per

Line 425: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date

421:
422: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
423: is
424: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
425: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
426: FROM per_all_assignments_f asg1
427: ,per_all_assignments_f asg2
428: ,per_all_people_f per
429: ,pay_element_links_f el

Line 707: , p_action_information9 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_from)

703: , p_action_information5 => g_local_unit_id
704: , p_action_information6 => L_LOCAL_UNIT_NAME
705: , p_action_information7 => l_month --TO_CHAR(TO_DATE(g_month,'MM'),'MONTH')
706: , p_action_information8 => g_year
707: , p_action_information9 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_from)
708: , p_action_information10 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_to)
709: );
710: -- *****************************************************************************
711:

Line 708: , p_action_information10 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_to)

704: , p_action_information6 => L_LOCAL_UNIT_NAME
705: , p_action_information7 => l_month --TO_CHAR(TO_DATE(g_month,'MM'),'MONTH')
706: , p_action_information8 => g_year
707: , p_action_information9 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_from)
708: , p_action_information10 => FND_DATE.DATE_TO_CANONICAL(g_retroactive_payment_to)
709: );
710: -- *****************************************************************************
711:
712:

Line 961: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,

957: ORDER BY paaf.assignment_id;
958:
959: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
960: is
961: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
962: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
963: FROM per_all_assignments_f asg1
964: ,per_all_assignments_f asg2
965: ,per_all_people_f per

Line 962: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date

958:
959: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
960: is
961: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
962: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
963: FROM per_all_assignments_f asg1
964: ,per_all_assignments_f asg2
965: ,per_all_people_f per
966: ,pay_element_links_f el

Line 3769: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,

3765: SELECT pai.action_information3 legal_employer,
3766: pai1.action_information4 local_unit,
3767: pai.action_information7 month,
3768: pai.action_information8 year,
3769: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3770: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to,
3771: decode(pai2.action_information4,0,NULL,pai2.action_information4) bh_worked_calendar_month,
3772: decode(pai2.action_information5,0,NULL,pai2.action_information5) bh_worked_payment_period,
3773: decode(pai2.action_information12,0,NULL,pai2.action_information12) bh_pbt_value,

Line 3770: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to,

3766: pai1.action_information4 local_unit,
3767: pai.action_information7 month,
3768: pai.action_information8 year,
3769: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3770: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to,
3771: decode(pai2.action_information4,0,NULL,pai2.action_information4) bh_worked_calendar_month,
3772: decode(pai2.action_information5,0,NULL,pai2.action_information5) bh_worked_payment_period,
3773: decode(pai2.action_information12,0,NULL,pai2.action_information12) bh_pbt_value,
3774: decode(pai2.action_information13,0,NULL,pai2.action_information13) bh_pcow_value,

Line 3863: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,

3859: SELECT pai.action_information3 legal_employer,
3860: pai1.action_information4 local_unit,
3861: pai.action_information7 || ' ' || pai.action_information8 period,-- month,
3862: --pai.action_information8 year,
3863: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3864: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to
3865: FROM
3866: pay_action_information pai,
3867: pay_action_information pai1,

Line 3864: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to

3860: pai1.action_information4 local_unit,
3861: pai.action_information7 || ' ' || pai.action_information8 period,-- month,
3862: --pai.action_information8 year,
3863: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3864: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to
3865: FROM
3866: pay_action_information pai,
3867: pay_action_information pai1,
3868: pay_payroll_actions ppa