APPS.PAY_KW_XDO_TEMPLATE dependencies on PER_GB_XDO_TEMPLATES

Line 24: DELETE FROM per_gb_xdo_templates

20: FROM fnd_lobs
21: WHERE file_id = p_file_id;
22:
23: -- the delete will ensure that the patch is rerunnable!
24: DELETE FROM per_gb_xdo_templates
25: WHERE file_name = l_file_name AND
26: effective_start_date = l_start_date AND
27: effective_end_date = l_end_date;
28:

Line 29: INSERT INTO per_gb_xdo_templates

25: WHERE file_name = l_file_name AND
26: effective_start_date = l_start_date AND
27: effective_end_date = l_end_date;
28:
29: INSERT INTO per_gb_xdo_templates
30: (file_id,
31: file_name,
32: file_description,
33: effective_start_date,

Line 61: DELETE FROM per_gb_xdo_templates

57: FROM fnd_lobs
58: WHERE file_id = p_file_id;
59:
60: -- the delete will ensure that the patch is rerunnable!
61: DELETE FROM per_gb_xdo_templates
62: WHERE file_name = l_file_name AND
63: effective_start_date = l_start_date AND
64: effective_end_date = l_end_date;
65:

Line 66: INSERT INTO per_gb_xdo_templates

62: WHERE file_name = l_file_name AND
63: effective_start_date = l_start_date AND
64: effective_end_date = l_end_date;
65:
66: INSERT INTO per_gb_xdo_templates
67: (file_id,
68: file_name,
69: file_description,
70: effective_start_date,