1503: Cursor cur_apl(p_topic_id irc_comm_topics.communication_topic_id%TYPE) is
1504: --get applicant for application attached to the given topic
1505: select paf.person_id
1506: from
1507: per_all_assignments_f paf,
1508: irc_communications ic,
1509: irc_comm_topics ict
1510: where
1511: ict.communication_topic_id = p_topic_id
1979: --needs to be created.
1980: --
1981: cursor cur_get_comm_property(p_assignment_id number) is
1982: select communication_property_id from irc_comm_properties where
1983: object_id = (select distinct vacancy_id from per_all_assignments_f where
1984: assignment_id =p_assignment_id )
1985: and object_type ='VACANCY' ;
1986:
1987: cursor cur_get_default_comm_status(p_assignment_id number) is
1985: and object_type ='VACANCY' ;
1986:
1987: cursor cur_get_default_comm_status(p_assignment_id number) is
1988: select default_comm_status from irc_comm_properties where
1989: object_id = (select distinct vacancy_id from per_all_assignments_f where
1990: assignment_id =p_assignment_id )
1991: and object_type ='VACANCY' ;
1992:
1993:
2097: --needs to be created.
2098: --
2099: cursor cur_get_comm_property(p_assignment_id number) is
2100: select communication_property_id from irc_comm_properties where
2101: object_id = (select distinct vacancy_id from per_all_assignments_f where
2102: assignment_id =p_assignment_id )
2103: and object_type ='VACANCY' ;
2104: --
2105: --
2104: --
2105: --
2106: cursor cur_get_default_comm_status(p_assignment_id number) is
2107: select default_comm_status from irc_comm_properties where
2108: object_id = (select distinct vacancy_id from per_all_assignments_f where
2109: assignment_id =p_assignment_id )
2110: and object_type ='VACANCY';
2111: --
2112: l_assignmentIdArray assoc_arr;