DBA Data[Home] [Help]

APPS.HR_KI_WF_MISC dependencies on ECX_TP_HEADERS_V

Line 100: l_party_id ecx_tp_headers_v.party_id%type;

96: IS
97:
98: l_trans_type ecx_tp_details_v.transaction_type%type;
99: l_trans_subtype ecx_tp_details_v.transaction_subtype%type;
100: l_party_id ecx_tp_headers_v.party_id%type;
101: l_party_site_id ecx_tp_headers_v.party_site_id%type;
102:
103: l_enabled number;
104: BEGIN

Line 101: l_party_site_id ecx_tp_headers_v.party_site_id%type;

97:
98: l_trans_type ecx_tp_details_v.transaction_type%type;
99: l_trans_subtype ecx_tp_details_v.transaction_subtype%type;
100: l_party_id ecx_tp_headers_v.party_id%type;
101: l_party_site_id ecx_tp_headers_v.party_site_id%type;
102:
103: l_enabled number;
104: BEGIN
105: if (funcmode = 'RUN') then

Line 126: from ecx_tp_headers_v eth

122:
123:
124: select etd.confirmation
125: into l_enabled
126: from ecx_tp_headers_v eth
127: ,ecx_tp_details_v etd
128: where eth.tp_header_id=etd.tp_header_id
129: and eth.party_id = l_party_id
130: and eth.party_site_id =l_party_site_id