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_AC_ACTION_ARCH dependencies on PER_ASSIGNMENTS_F

Line 1878: FROM per_assignments_f paf

1874: CURSOR c_cur_get_wrkathome(cp_assignment_id IN NUMBER) IS
1875: SELECT NVL(paf.work_at_home, 'N')
1876: ,ppf.person_id
1877: ,ppf.business_group_id
1878: FROM per_assignments_f paf
1879: ,per_all_people_f ppf
1880: WHERE paf.assignment_id = cp_assignment_id
1881: AND paf.person_id = ppf.person_id;
1882:

Line 2046: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;

2042: lv_retro_parent_flag varchar2(10) := 'N';
2043: lv_sqlstr1 varchar2(2000);
2044: lv_curr_pymt_eff_date VARCHAR2(100);
2045: -- Added For Work At Home Condition
2046: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;
2047: ln_person_id per_people_f.person_id%TYPE;
2048: ln_bg_id per_people_f.business_group_id%TYPE;
2049:
2050: BEGIN

Line 4347: FROM per_assignments_f paf

4343: CURSOR c_cur_get_wrkathome(cp_assignment_id IN NUMBER) IS
4344: SELECT NVL(paf.work_at_home, 'N')
4345: ,ppf.person_id
4346: ,ppf.business_group_id
4347: FROM per_assignments_f paf
4348: ,per_all_people_f ppf
4349: WHERE paf.assignment_id = cp_assignment_id
4350: AND paf.person_id = ppf.person_id;
4351:

Line 4407: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;

4403: ln_pay_value number (15,5);
4404: ln_hours number(15,5) ;
4405: ln_amount number(15,5);
4406: -- Added For Work At Home Condition
4407: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;
4408: ln_person_id per_people_f.person_id%TYPE;
4409: ln_bg_id per_people_f.business_group_id%TYPE;
4410:
4411: BEGIN

Line 4849: FROM per_assignments_f paf

4845: CURSOR c_cur_get_wrkathome(cp_assignment_id IN NUMBER) IS
4846: SELECT NVL(paf.work_at_home, 'N')
4847: ,ppf.person_id
4848: ,ppf.business_group_id
4849: FROM per_assignments_f paf
4850: ,per_all_people_f ppf
4851: WHERE paf.assignment_id = cp_assignment_id
4852: AND paf.person_id = ppf.person_id;
4853:

Line 4917: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;

4913: lv_sqlstr4 varchar2(2500);
4914: lv_sqlstr_final varchar2(2500);
4915:
4916: -- Added For Work At Home Condition
4917: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;
4918: ln_person_id per_people_f.person_id%TYPE;
4919: ln_bg_id per_people_f.business_group_id%TYPE;
4920:
4921: BEGIN