DBA Data[Home] [Help]

APPS.PAY_NL_GENERAL dependencies on PAY_RETRO_ASSIGNMENTS

Line 2673: pay_retro_assignments pra,

2669: CURSOR c_valid_assignments
2670: IS
2671: select distinct pra.assignment_id, pra.retro_assignment_id
2672: from
2673: pay_retro_assignments pra,
2674: per_all_assignments_f paaf
2675: where
2676: pra.assignment_id = paaf.assignment_id
2677: and pra.reprocess_date >= fnd_date.canonical_to_date(p_reprocess_date) --from conc parameter

Line 2754: pay_retro_assignments pra,

2750: CURSOR c_adj_processed
2751: IS
2752: select 1
2753: from
2754: pay_retro_assignments pra,
2755: pay_retro_entries pre,
2756: pay_element_entries_f peef,
2757: pay_element_types_f petf,
2758: pay_retro_components prc