DBA Data[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGF_AP_TD_ITEM_MST

Line 1833: FROM igf_ap_td_item_mst im

1829: */
1830:
1831: CURSOR todo_items_for_profile_cur IS
1832: SELECT im.*
1833: FROM igf_ap_td_item_mst im
1834: WHERE im.system_todo_type_code = 'PROFILE' -- for PROFILE type only
1835: AND im.ci_cal_type = g_ci_cal_type
1836: AND im.ci_sequence_number = g_ci_sequence_number;
1837:

Line 1840: FROM igf_ap_td_item_inst ii, igf_ap_td_item_mst im

1836: AND im.ci_sequence_number = g_ci_sequence_number;
1837:
1838: CURSOR check_todo_exists_inst_cur(lp_base_id NUMBER, p_item_seq_num NUMBER) IS
1839: SELECT ii.rowid, ii.*
1840: FROM igf_ap_td_item_inst ii, igf_ap_td_item_mst im
1841: WHERE ii.item_sequence_number = im.todo_number
1842: AND im.system_todo_type_code = 'PROFILE'
1843: AND im.ci_cal_type = g_ci_cal_type
1844: AND im.ci_sequence_number = g_ci_sequence_number