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 PAY_BALANCE_FEEDS_F

Line 92: (input_value_id pay_balance_feeds_f.input_value_id%type,

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,
94: effective_start_date pay_balance_feeds_f.effective_start_date%type,
95: effective_end_date pay_balance_feeds_f.effective_end_date%type,
96: scale pay_balance_feeds_f.scale%type

Line 94: effective_start_date pay_balance_feeds_f.effective_start_date%type,

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,
94: effective_start_date pay_balance_feeds_f.effective_start_date%type,
95: effective_end_date pay_balance_feeds_f.effective_end_date%type,
96: scale pay_balance_feeds_f.scale%type
97: );
98: --

Line 95: effective_end_date pay_balance_feeds_f.effective_end_date%type,

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,
94: effective_start_date pay_balance_feeds_f.effective_start_date%type,
95: effective_end_date pay_balance_feeds_f.effective_end_date%type,
96: scale pay_balance_feeds_f.scale%type
97: );
98: --
99: type t_feeds_tab is table of t_feed_rec index by binary_integer;

Line 96: scale pay_balance_feeds_f.scale%type

92: (input_value_id pay_balance_feeds_f.input_value_id%type,
93: element_type_id pay_input_values_f.element_type_id%type,
94: effective_start_date pay_balance_feeds_f.effective_start_date%type,
95: effective_end_date pay_balance_feeds_f.effective_end_date%type,
96: scale pay_balance_feeds_f.scale%type
97: );
98: --
99: type t_feeds_tab is table of t_feed_rec index by binary_integer;
100: g_feeds_tab t_feeds_tab;

Line 7849: ,pay_balance_feeds_f pbf

7845: /*+ ORDERED USE_NL(pbf, pdb, pbd, prrv) */
7846: distinct pdb.defined_balance_id
7847: from
7848: pay_input_values_f piv
7849: ,pay_balance_feeds_f pbf
7850: ,pay_defined_balances pdb
7851: ,pay_balance_dimensions pbd
7852: ,pay_run_result_values prrv
7853: where

Line 8623: pay_balance_feeds_f pbf,

8619: from
8620: pay_assignment_actions paa,
8621: pay_run_results prr,
8622: pay_input_values_f piv,
8623: pay_balance_feeds_f pbf,
8624: pay_balance_types pbt,
8625: pay_defined_balances pdb,
8626: pay_balance_dimensions pbd,
8627: pay_run_result_values prrv

Line 8668: -- pay_balance_feeds_f pbf

8664: and prrv.result_value is not null;
8665: -- and exists (select /*+ ORDERED */ ''
8666: -- from pay_run_results prr,
8667: -- pay_run_result_values prrv,
8668: -- pay_balance_feeds_f pbf
8669: -- where prr.assignment_action_id = p_asg_act_id
8670: -- and prr.run_result_id = prrv.run_result_id
8671: -- and prrv.input_value_id = pbf.input_value_id
8672: -- and pbf.balance_type_id = pbt.balance_type_id);

Line 8700: pay_balance_feeds_f pbf

8696: and exists (select /*+ ORDERED */ ''
8697: from pay_assignment_actions paa,
8698: pay_run_results prr,
8699: pay_run_result_values prrv,
8700: pay_balance_feeds_f pbf
8701: where paa.payroll_action_id = p_pact_id
8702: and prr.assignment_action_id = paa.assignment_action_id
8703: and prr.run_result_id = prrv.run_result_id
8704: and prrv.input_value_id = pbf.input_value_id

Line 8731: pay_balance_feeds_f pbf

8727: distinct pbf.balance_type_id
8728: from pay_assignment_actions paa,
8729: pay_run_results prr,
8730: pay_run_result_values prrv,
8731: pay_balance_feeds_f pbf
8732: where paa.payroll_action_id = p_pact_id
8733: and prr.assignment_action_id = paa.assignment_action_id
8734: and prr.run_result_id = prrv.run_result_id
8735: and prrv.input_value_id = pbf.input_value_id

Line 8772: pay_balance_feeds_f pbf

8768: distinct pbf.balance_type_id
8769: from pay_assignment_actions paa,
8770: pay_run_results prr,
8771: pay_run_result_values prrv,
8772: pay_balance_feeds_f pbf
8773: where paa.payroll_action_id = p_pact_id
8774: and prr.assignment_action_id = paa.assignment_action_id
8775: and prr.run_result_id = prrv.run_result_id
8776: and prrv.input_value_id = pbf.input_value_id

Line 9490: pay_balance_feeds_f pbf,

9486: pbd.balance_dimension_id
9487: from
9488: pay_run_results prr,
9489: pay_run_result_values prrv,
9490: pay_balance_feeds_f pbf,
9491: pay_balance_types pbt,
9492: pay_defined_balances pdb,
9493: pay_balance_dimensions pbd
9494: where pbd.dimension_level = 'ASG'

Line 9526: -- pay_balance_feeds_f pbf

9522: and pbt.balance_type_id = pbf.balance_type_id;
9523: -- and exists (select /*+ ORDERED */ ''
9524: -- from pay_run_results prr,
9525: -- pay_run_result_values prrv,
9526: -- pay_balance_feeds_f pbf
9527: -- where prr.assignment_action_id = p_asg_act_id
9528: -- and prr.run_result_id = prrv.run_result_id
9529: -- and prrv.input_value_id = pbf.input_value_id
9530: -- and pbf.balance_type_id = pbt.balance_type_id);

Line 9560: from pay_balance_feeds_f pbf

9556: pay_run_result_values prrv
9557: where prr.assignment_action_id = p_asg_act_id
9558: and prr.run_result_id = prrv.run_result_id
9559: and exists ( select /*+ no_unnest */ ''
9560: from pay_balance_feeds_f pbf
9561: where pbf.input_value_id = prrv.input_value_id
9562: and pbf.balance_type_id = pdb.balance_type_id )
9563: );
9564: cursor crs_balatt_2 (p_asg_act_id number

Line 9588: pay_balance_feeds_f pbf

9584: (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
9585: distinct pbf.balance_type_id
9586: from pay_run_results prr,
9587: pay_run_result_values prrv,
9588: pay_balance_feeds_f pbf
9589: where prr.assignment_action_id = p_asg_act_id
9590: and prr.run_result_id = prrv.run_result_id
9591: and prrv.input_value_id = pbf.input_value_id);
9592: --

Line 9627: -- pay_balance_feeds_f pbf

9623: -- (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
9624: -- distinct pbf.balance_type_id
9625: -- from pay_run_results prr,
9626: -- pay_run_result_values prrv,
9627: -- pay_balance_feeds_f pbf
9628: -- where prr.assignment_action_id = p_asg_act_id
9629: -- and prr.run_result_id = prrv.run_result_id
9630: -- and prrv.input_value_id = pbf.input_value_id
9631: -- );

Line 9657: pay_balance_feeds_f pbf,

9653: pdb.balance_dimension_id
9654: from
9655: pay_run_results prr,
9656: pay_input_values_f piv,
9657: pay_balance_feeds_f pbf,
9658: pay_defined_balances pdb,
9659: pay_balance_attributes pba,
9660: pay_balance_dimensions pbd,
9661: pay_balance_validation pbv,

Line 10792: from pay_balance_feeds_f bf

10788: select 1
10789: from dual
10790: where exists (select /*+ ORDERED*/
10791: null
10792: from pay_balance_feeds_f bf
10793: , pay_run_result_values rrv
10794: where bf.balance_type_id = p_baltype_id
10795: and bf.input_value_id = rrv.input_value_id);
10796: --

Line 11412: from pay_balance_feeds_f f, pay_input_values_f i

11408: cursor csr_feed(p_balance_type_id number , p_business_group_id number, p_from_date date ) is
11409:
11410: select distinct f.input_value_id , i.element_type_id, f.effective_start_date, f.effective_end_date,
11411: f.scale
11412: from pay_balance_feeds_f f, pay_input_values_f i
11413: where f.balance_type_id = p_balance_type_id
11414: and (f.business_group_id is null or f.business_group_id = p_business_group_id)
11415: and f.effective_end_date >= p_from_date
11416: and i.input_value_id = f.input_value_id

Line 11485: from pay_balance_feeds_f f, pay_input_values_f i

11481: close csr_feed;
11482:
11483: select distinct f.input_value_id , i.element_type_id, f.balance_feed_id
11484: bulk collect into g_feed_input_tab, g_feed_element_tab, g_feed_feed_tab
11485: from pay_balance_feeds_f f, pay_input_values_f i
11486: where f.balance_type_id = g_balance_type_id
11487: and (f.business_group_id is null or f.business_group_id = p_business_group_id)
11488: and f.effective_end_date >= p_from_date
11489: and i.input_value_id = f.input_value_id

Line 11548: pay_balance_feeds_f feed

11544: pay_assignment_actions assact,
11545: pay_payroll_actions pact,
11546: pay_run_results rr,
11547: pay_run_result_values rrv,
11548: pay_balance_feeds_f feed
11549: where assact.assignment_id = g_assignment_id
11550: --and assact.assignment_action_id in
11551: -- ( select assignment_action_id from pay_assignment_actions where assignment_id = g_assignment_id
11552: -- minus select source_action_id from pay_assignment_actions where assignment_id = g_assignment_id)

Line 11709: from pay_balance_feeds_f f, pay_input_values_f i

11705: cursor csr_feed(p_balance_type_id number , p_business_group_id number, p_from_date date ) is
11706:
11707: select distinct f.input_value_id , i.element_type_id, f.effective_start_date, f.effective_end_date,
11708: f.scale
11709: from pay_balance_feeds_f f, pay_input_values_f i
11710: where f.balance_type_id = p_balance_type_id
11711: and (f.business_group_id is null or f.business_group_id = p_business_group_id)
11712: and f.effective_end_date >= p_from_date
11713: and i.input_value_id = f.input_value_id

Line 11786: from pay_balance_feeds_f f, pay_input_values_f i

11782: close csr_feed;
11783:
11784: select distinct f.input_value_id , i.element_type_id, f.balance_feed_id
11785: bulk collect into g_feed_input_tab, g_feed_element_tab, g_feed_feed_tab
11786: from pay_balance_feeds_f f, pay_input_values_f i
11787: where f.balance_type_id = g_balance_type_id
11788: and (f.business_group_id is null or f.business_group_id = p_business_group_id)
11789: and f.effective_end_date >= p_from_date
11790: and i.input_value_id = f.input_value_id

Line 11853: pay_balance_feeds_f feed

11849: pay_assignment_actions assact,
11850: pay_payroll_actions pact,
11851: pay_run_results rr,
11852: pay_run_result_values rrv,
11853: pay_balance_feeds_f feed
11854: where gen_assact.payroll_action_id = p_generate_pact
11855: and gen_assact.chunk_number = g_chunk_number
11856: and assact.assignment_id = gen_assact.assignment_id
11857: and pact.payroll_action_id = assact.payroll_action_id