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.

[Home] [Help]

APPS.PAY_CA_EOY_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 665: INDEX (asg PER_ASSIGNMENTS_F_N12)

661: */
662:
663: CURSOR c_eoy_gre IS
664: SELECT /*+ Ordered
665: INDEX (asg PER_ASSIGNMENTS_F_N12)
666: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
667: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
668: DISTINCT ASG.person_id person_id
669: FROM

Line 784: INDEX (asg PER_ASSIGNMENTS_F_N12)

780: /* Cursor to get the latest assignment_action_id based
781: on person_id. Bug#3267520 */
782: CURSOR c_get_latest_asg(p_person_id number ) IS
783: select /*+ Ordered
784: INDEX (asg PER_ASSIGNMENTS_F_N12)
785: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
786: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
787: paa.assignment_action_id
788: from per_all_assignments_f paf,

Line 2277: l_each_asgid per_assignments_f.assignment_id%type;

2273: -- l_screen_entry_value added by sneelapa for bug 6399498
2274: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
2275:
2276: l_each_person_id per_all_people_f.person_id%type;
2277: l_each_asgid per_assignments_f.assignment_id%type;
2278:
2279: -- added for bug 10244185
2280: lv_code87_Maxlimit varchar2(30);
2281: lv_code87_excess_amt number := 0;

Line 4417: ASG PER_ASSIGNMENTS_F_PK,

4413:
4414: sqlstr := 'select /*+ ORDERED INDEX (PPY PAY_PAYROLLS_F_FK2,
4415: PPA PAY_PAYROLL_ACTIONS_N51,
4416: PAA PAY_ASSIGNMENT_ACTIONS_N50,
4417: ASG PER_ASSIGNMENTS_F_PK,
4418: PPA1 PAY_PAYROLL_ACTIONS_PK)
4419: USE_NL(PPY, PPA, PAA, ASG, PPA1) */
4420: distinct asg.person_id
4421: from pay_all_payrolls_f ppy,