eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BALANCE_PKG dependencies on FND_TABLE_OF_NUMBER

Line 87: g_feed_input_tab FND_TABLE_OF_NUMBER;

83: g_defined_balance_id pay_defined_balances.defined_balance_id%type;
84: g_balance_type_id pay_defined_balances.balance_type_id%type;
85: g_business_group_id per_all_assignments_f.business_group_id%type;
86:
87: g_feed_input_tab FND_TABLE_OF_NUMBER;
88: g_feed_element_tab FND_TABLE_OF_NUMBER;
89: g_feed_feed_tab FND_TABLE_OF_NUMBER;
90:
91: type t_feed_rec is record

Line 88: g_feed_element_tab FND_TABLE_OF_NUMBER;

84: g_balance_type_id pay_defined_balances.balance_type_id%type;
85: g_business_group_id per_all_assignments_f.business_group_id%type;
86:
87: g_feed_input_tab FND_TABLE_OF_NUMBER;
88: g_feed_element_tab FND_TABLE_OF_NUMBER;
89: g_feed_feed_tab FND_TABLE_OF_NUMBER;
90:
91: type t_feed_rec is record
92: (input_value_id pay_balance_feeds_f.input_value_id%type,

Line 89: g_feed_feed_tab FND_TABLE_OF_NUMBER;

85: g_business_group_id per_all_assignments_f.business_group_id%type;
86:
87: g_feed_input_tab FND_TABLE_OF_NUMBER;
88: g_feed_element_tab FND_TABLE_OF_NUMBER;
89: g_feed_feed_tab FND_TABLE_OF_NUMBER;
90:
91: type t_feed_rec is record
92: (input_value_id pay_balance_feeds_f.input_value_id%type,
93: element_type_id pay_input_values_f.element_type_id%type,

Line 11558: and rr.element_type_id in ( select * from table(CAST(g_feed_element_tab AS FND_TABLE_OF_NUMBER)) )

11554: and pact.action_type in ('R', 'Q', 'V', 'B', 'I')
11555: and pact.effective_date >= nvl(p_from_date, pact.effective_date)
11556: and rr.assignment_action_id = assact.assignment_action_id
11557: and rr.status in ('P','PA')
11558: and rr.element_type_id in ( select * from table(CAST(g_feed_element_tab AS FND_TABLE_OF_NUMBER)) )
11559: and rrv.run_result_id = rr.run_result_id
11560: and nvl(rrv.result_value, '0') <> '0'
11561: --and rrv.input_value_id in ( select * from table(CAST(g_feed_input_tab AS FND_TABLE_OF_NUMBER)) )
11562: and pact.effective_date between feed.effective_start_date and feed.effective_end_date

Line 11561: --and rrv.input_value_id in ( select * from table(CAST(g_feed_input_tab AS FND_TABLE_OF_NUMBER)) )

11557: and rr.status in ('P','PA')
11558: and rr.element_type_id in ( select * from table(CAST(g_feed_element_tab AS FND_TABLE_OF_NUMBER)) )
11559: and rrv.run_result_id = rr.run_result_id
11560: and nvl(rrv.result_value, '0') <> '0'
11561: --and rrv.input_value_id in ( select * from table(CAST(g_feed_input_tab AS FND_TABLE_OF_NUMBER)) )
11562: and pact.effective_date between feed.effective_start_date and feed.effective_end_date
11563: and feed.input_value_id = rrv.input_value_id
11564: and feed.balance_type_id = g_balance_type_id
11565: --and feed.balance_feed_id in ( select * from table(CAST(g_feed_feed_tab AS FND_TABLE_OF_NUMBER)) )

Line 11565: --and feed.balance_feed_id in ( select * from table(CAST(g_feed_feed_tab AS FND_TABLE_OF_NUMBER)) )

11561: --and rrv.input_value_id in ( select * from table(CAST(g_feed_input_tab AS FND_TABLE_OF_NUMBER)) )
11562: and pact.effective_date between feed.effective_start_date and feed.effective_end_date
11563: and feed.input_value_id = rrv.input_value_id
11564: and feed.balance_type_id = g_balance_type_id
11565: --and feed.balance_feed_id in ( select * from table(CAST(g_feed_feed_tab AS FND_TABLE_OF_NUMBER)) )
11566: group by assact.assignment_action_id order by assact.assignment_action_id;
11567: end if; --} primary balance
11568: end if; --} feeds exist
11569: if g_debug then

Line 11862: and rr.element_type_id in ( select * from table(CAST(g_feed_element_tab AS FND_TABLE_OF_NUMBER)) )

11858: and pact.action_type in ('R', 'Q', 'V', 'B', 'I')
11859: and pact.effective_date >= nvl(p_from_date, pact.effective_date)
11860: and rr.assignment_action_id = assact.assignment_action_id
11861: and rr.status in ('P','PA')
11862: and rr.element_type_id in ( select * from table(CAST(g_feed_element_tab AS FND_TABLE_OF_NUMBER)) )
11863: and rrv.run_result_id = rr.run_result_id
11864: and nvl(rrv.result_value, '0') <> '0'
11865: --and rrv.input_value_id in ( select * from table(CAST(g_feed_input_tab AS FND_TABLE_OF_NUMBER)) )
11866: and pact.effective_date between feed.effective_start_date and feed.effective_end_date

Line 11865: --and rrv.input_value_id in ( select * from table(CAST(g_feed_input_tab AS FND_TABLE_OF_NUMBER)) )

11861: and rr.status in ('P','PA')
11862: and rr.element_type_id in ( select * from table(CAST(g_feed_element_tab AS FND_TABLE_OF_NUMBER)) )
11863: and rrv.run_result_id = rr.run_result_id
11864: and nvl(rrv.result_value, '0') <> '0'
11865: --and rrv.input_value_id in ( select * from table(CAST(g_feed_input_tab AS FND_TABLE_OF_NUMBER)) )
11866: and pact.effective_date between feed.effective_start_date and feed.effective_end_date
11867: and feed.input_value_id = rrv.input_value_id
11868: and feed.balance_type_id = g_balance_type_id
11869: --and feed.balance_feed_id in ( select * from table(CAST(g_feed_feed_tab AS FND_TABLE_OF_NUMBER)) )

Line 11869: --and feed.balance_feed_id in ( select * from table(CAST(g_feed_feed_tab AS FND_TABLE_OF_NUMBER)) )

11865: --and rrv.input_value_id in ( select * from table(CAST(g_feed_input_tab AS FND_TABLE_OF_NUMBER)) )
11866: and pact.effective_date between feed.effective_start_date and feed.effective_end_date
11867: and feed.input_value_id = rrv.input_value_id
11868: and feed.balance_type_id = g_balance_type_id
11869: --and feed.balance_feed_id in ( select * from table(CAST(g_feed_feed_tab AS FND_TABLE_OF_NUMBER)) )
11870: group by assact.assignment_action_id order by assact.assignment_action_id;
11871: end if; --} primary balance
11872: end if; --} feeds exist
11873: if g_debug then