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 573: FROM dual;

569:
570: IF (ln_person_id <> ln_prev_person_id) THEN
571: SELECT pay_assignment_actions_s.nextval
572: INTO ln_affl_asg_act
573: FROM dual;
574:
575: hr_utility_trace('Creating affiliation report assignment action '||
576: ln_affl_asg_act);
577: hr_nonrun_asact.insact(ln_affl_asg_act,

Line 851: FROM dual

847: CURSOR csr_asg_actions (cp_person_id number) IS
848: /*SELECT fnd_number.canonical_to_number(
849: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
850: fnd_date.canonical_to_date (g_end_date)
851: FROM dual
852: UNION
853: SELECT paa.assignment_action_id,
854: fnd_date.canonical_to_date(
855: pay_mx_utility.get_legi_param_val('END_DATE',