APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on DUAL

Line 626: FROM DUAL;

622: ELSE
623:
624: SELECT fnd_date.date_to_canonical(sysdate)
625: INTO lv_start_date
626: FROM DUAL;
627:
628: END IF; -- p_gre_id IS NOT NULL
629:
630: END IF; -- ld_start_date <> hr_api.g_sot

Line 652: FROM dual;

648: fnd_date.canonical_to_date( p_date ), -1 ) ) || ' - ' ||
649: fnd_date.date_to_displaydate( ADD_MONTHS (
650: fnd_date.canonical_to_date( p_date ), 1 ) -1 )
651: INTO lv_dates
652: FROM dual;
653:
654: RETURN lv_dates;
655:
656: END get_dates_for_valueset;

Line 1717: FROM DUAL;

1713: -- Bug 5552692
1714: SELECT DECODE (c_infonavit_info_rec.screen_entry_value,
1715: 'Y', 'S',
1716: 'N') INTO trn(p_index).redxn_table_applies
1717: FROM DUAL;
1718: END IF;
1719: END LOOP;
1720: END load_infonavit_info;
1721:

Line 1871: FROM dual;

1867: TRUNC (ld_hire_anniversary, 'Y'))
1868: ) +
1869: (ld_hire_anniversary - TRUNC (ld_hire_anniversary, 'MM'))
1870: INTO ld_anniversary_date
1871: FROM dual;
1872:
1873: hr_utility_trace ('Anniversary date of person '||p_person_id||
1874: ' in the year of archiver run = '||
1875: fnd_date.date_to_canonical(ld_anniversary_date));

Line 4958: FROM dual;

4954: hr_utility_trace('IMPLEMENTATION TRUE');
4955:
4956: SELECT pay_assignment_actions_s.nextval
4957: INTO ln_asg_act_id
4958: FROM dual;
4959:
4960: hr_utility_trace('--> Inserting into pay_assignment_actions' );
4961: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4962: -- insert into pay_assignment_actions.

Line 5030: FROM dual;

5026: fnd_date.canonical_to_date(lv_start_date)) = 'Y') THEN
5027: hr_utility_trace('--> Inside If ' );
5028: SELECT pay_assignment_actions_s.nextval
5029: INTO ln_asg_act_id
5030: FROM dual;
5031:
5032: hr_utility_trace('--> insert into pay_assignment_actions.' );
5033: -- insert into pay_assignment_actions.
5034: hr_nonrun_asact.insact(ln_asg_act_id,