DBA Data[Home] [Help]

APPS.PAY_AC_ACTION_ARCH dependencies on PER_PEOPLE_F

Line 2404: ln_person_id per_people_f.person_id%TYPE;

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
2408: lv_sqlstr_final varchar2(10000);

Line 2405: ln_bg_id per_people_f.business_group_id%TYPE;

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
2408: lv_sqlstr_final varchar2(10000);
2409: lv_sqlstr_date varchar2(10000);

Line 4959: ln_person_id per_people_f.person_id%TYPE;

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:
4963: ln_rate_disp NUMBER; -- 12548215

Line 4960: ln_bg_id per_people_f.business_group_id%TYPE;

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:
4963: ln_rate_disp NUMBER; -- 12548215
4964: ln_hours_derv_flag boolean; -- 12548215

Line 5539: ln_person_id per_people_f.person_id%TYPE;

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
5543:

Line 5540: ln_bg_id per_people_f.business_group_id%TYPE;

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
5543:
5544: hr_utility.trace('Entering in package Archive_addnl_elements');

Line 6140: ln_person_id per_people_f.person_id%TYPE;

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
6144:

Line 6141: ln_bg_id per_people_f.business_group_id%TYPE;

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
6144:
6145: hr_utility.trace('Entering in package Archive_addnl_elements');