APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on DUAL

Line 557: FROM DUAL;

553: ELSE
554:
555: SELECT fnd_date.date_to_canonical(sysdate)
556: INTO lv_start_date
557: FROM DUAL;
558:
559: END IF; -- p_gre_id IS NOT NULL
560:
561: END IF; -- ld_start_date <> hr_api.g_sot

Line 583: FROM dual;

579: fnd_date.canonical_to_date( p_date ), -1 ) ) || ' - ' ||
580: fnd_date.date_to_displaydate( ADD_MONTHS (
581: fnd_date.canonical_to_date( p_date ), 1 ) -1 )
582: INTO lv_dates
583: FROM dual;
584:
585: RETURN lv_dates;
586:
587: END get_dates_for_valueset;

Line 1632: FROM DUAL;

1628: -- Bug 5552692
1629: SELECT DECODE (c_infonavit_info_rec.screen_entry_value,
1630: 'Y', 'S',
1631: 'N') INTO trn(p_index).redxn_table_applies
1632: FROM DUAL;
1633: END IF;
1634: END LOOP;
1635: END load_infonavit_info;
1636:

Line 1786: FROM dual;

1782: TRUNC (ld_hire_anniversary, 'Y'))
1783: ) +
1784: (ld_hire_anniversary - TRUNC (ld_hire_anniversary, 'MM'))
1785: INTO ld_anniversary_date
1786: FROM dual;
1787:
1788: hr_utility_trace ('Anniversary date of person '||p_person_id||
1789: ' in the year of archiver run = '||
1790: fnd_date.date_to_canonical(ld_anniversary_date));

Line 4491: FROM dual;

4487: hr_utility_trace('IMPLEMENTATION TRUE');
4488:
4489: SELECT pay_assignment_actions_s.nextval
4490: INTO ln_asg_act_id
4491: FROM dual;
4492:
4493: hr_utility_trace('--> Inserting into pay_assignment_actions' );
4494: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4495: -- insert into pay_assignment_actions.

Line 4563: FROM dual;

4559: fnd_date.canonical_to_date(lv_start_date)) = 'Y') THEN
4560: hr_utility_trace('--> Inside If ' );
4561: SELECT pay_assignment_actions_s.nextval
4562: INTO ln_asg_act_id
4563: FROM dual;
4564:
4565: hr_utility_trace('--> insert into pay_assignment_actions.' );
4566: -- insert into pay_assignment_actions.
4567: hr_nonrun_asact.insact(ln_asg_act_id,