APPS.PER_MX_SS_AFFILIATION dependencies on DUAL

Line 68: dual maintenance.

64: sdahiya 15-May-2007 115.9 Modified action_creation and
65: generate_xml so that past-dated
66: transactions are picked.
67: sdahiya 16-May-2007 115.10 Version uprev after establishing
68: dual maintenance.
69: sdahiya 18-May-2007 115.11 6060070 Changed multiple SQL statements
70: to conditionally convert
71: canonical date stamped on DDF into
72: date.

Line 670: FROM dual;

666: IF (ln_exist = 0 OR l_report = 0) THEN
667: IF (ln_person_id <> ln_prev_person_id) THEN
668: SELECT pay_assignment_actions_s.nextval
669: INTO ln_affl_asg_act
670: FROM dual;
671:
672: hr_utility_trace('Creating affiliation report assignment action '||
673: ln_affl_asg_act);
674: hr_nonrun_asact.insact(ln_affl_asg_act,

Line 1001: FROM dual

997: CURSOR csr_asg_actions (cp_person_id number) IS
998: /*SELECT fnd_number.canonical_to_number(
999: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
1000: fnd_date.canonical_to_date (g_end_date)
1001: FROM dual
1002: UNION
1003: SELECT paa.assignment_action_id,
1004: fnd_date.canonical_to_date(
1005: pay_mx_utility.get_legi_param_val('END_DATE',