APPS.PAY_FI_ARCHIVE_PSTA dependencies on DUAL

Line 240: from dual;

236:
237: /* Get the Last Date of the Year */
238: select fnd_date.canonical_to_date (g_year || '12/31')
239: into g_year_last_date
240: from dual;
241:
242: /* Get the First Date of the Year */
243: g_year_start_date := add_months (g_year_last_date, -12) + 1;
244:

Line 764: from dual;

760: loop
761: if benefit_archive_details (k).benefit_name <> 'Car Benefit' then
762: select pay_assignment_actions_s.nextval
763: into l_actid
764: from dual;
765:
766: hr_nonrun_asact.insact (
767: l_actid,
768: benefit_archive_details (k).assignment_id,

Line 810: from dual;

806: )
807: loop
808: select pay_assignment_actions_s.nextval
809: into l_actid
810: from dual;
811:
812: hr_nonrun_asact.insact (
813: l_actid,
814: benefit_archive_details (k).assignment_id,

Line 887: from dual;

883: --
884: /* Get the Last Date of the Year */
885: select fnd_date.canonical_to_date (g_year || '12/31')
886: into g_year_last_date
887: from dual;
888:
889: /* Get the First Date of the Year */
890: g_year_start_date := add_months (g_year_last_date, -12) + 1;
891:

Line 907: from dual;

903:
904: if l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id then
905: select pay_assignment_actions_s.nextval
906: into l_actid
907: from dual;
908:
909: g_run_payroll_action_id := rec_prepaid_assignments.payroll_action_id;
910:
911: --