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 2233: FROM per_assignments_f paf

2229: p_curr_pymt_eff_date in Date) is -- Bug# 16318258
2230: SELECT NVL(paf.work_at_home, 'N')
2231: ,ppf.person_id
2232: ,ppf.business_group_id
2233: FROM per_assignments_f paf
2234: ,per_all_people_f ppf
2235: WHERE paf.assignment_id = cp_assignment_id
2236: AND paf.person_id = ppf.person_id
2237: and p_curr_pymt_eff_date between paf.effective_start_date and paf.effective_end_date

Line 2403: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;

2399: lv_retro_parent_flag varchar2(10) := 'N';
2400: lv_sqlstr1 varchar2(2000);
2401: lv_curr_pymt_eff_date VARCHAR2(100);
2402: -- Added For Work At Home Condition
2403: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;
2404: ln_person_id per_people_f.person_id%TYPE;
2405: ln_bg_id per_people_f.business_group_id%TYPE;
2406:
2407: -- lv_sqlstr_final, lv_sqlstr_date added by sneelapa for bug 13905220

Line 4895: FROM per_assignments_f paf

4891: ) IS
4892: SELECT NVL(paf.work_at_home, 'N')
4893: ,ppf.person_id
4894: ,ppf.business_group_id
4895: FROM per_assignments_f paf
4896: ,per_all_people_f ppf
4897: WHERE paf.assignment_id = cp_assignment_id
4898: AND paf.person_id = ppf.person_id
4899: and cp_pymt_eff_date between paf.effective_start_date and paf.effective_end_date

Line 4958: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;

4954: ln_pay_value number (15,5);
4955: ln_hours number(15,5) ;
4956: ln_amount number(15,5);
4957: -- Added For Work At Home Condition
4958: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;
4959: ln_person_id per_people_f.person_id%TYPE;
4960: ln_bg_id per_people_f.business_group_id%TYPE;
4961:
4962:

Line 5468: FROM per_assignments_f paf

5464: ) IS
5465: SELECT NVL(paf.work_at_home, 'N')
5466: ,ppf.person_id
5467: ,ppf.business_group_id
5468: FROM per_assignments_f paf
5469: ,per_all_people_f ppf
5470: WHERE paf.assignment_id = cp_assignment_id
5471: AND paf.person_id = ppf.person_id
5472: and cp_pymt_eff_date between paf.effective_start_date and paf.effective_end_date

Line 5538: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;

5534: lv_sqlstr4 varchar2(2500);
5535: lv_sqlstr_final varchar2(2500);
5536:
5537: -- Added For Work At Home Condition
5538: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;
5539: ln_person_id per_people_f.person_id%TYPE;
5540: ln_bg_id per_people_f.business_group_id%TYPE;
5541:
5542: BEGIN

Line 6069: FROM per_assignments_f paf

6065: ) IS
6066: SELECT NVL(paf.work_at_home, 'N')
6067: ,ppf.person_id
6068: ,ppf.business_group_id
6069: FROM per_assignments_f paf
6070: ,per_all_people_f ppf
6071: WHERE paf.assignment_id = cp_assignment_id
6072: AND paf.person_id = ppf.person_id
6073: and cp_pymt_eff_date between paf.effective_start_date and paf.effective_end_date

Line 6139: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;

6135: lv_sqlstr4 varchar2(2500);
6136: lv_sqlstr_final varchar2(2500);
6137:
6138: -- Added For Work At Home Condition
6139: lv_wrk_at_home per_assignments_f.work_at_home%TYPE;
6140: ln_person_id per_people_f.person_id%TYPE;
6141: ln_bg_id per_people_f.business_group_id%TYPE;
6142:
6143: BEGIN