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.HXT_TIMECARD_API dependencies on PAY_ACCRUAL_PLANS

Line 36: FROM pay_accrual_plans pap

32: CURSOR accrual_details_cur (p_accrual_plan_name VARCHAR2,
33: p_business_group_id NUMBER) IS
34: SELECT pap.accrual_category,
35: pap.accrual_plan_id
36: FROM pay_accrual_plans pap
37: WHERE pap.accrual_plan_name=p_accrual_plan_name
38: AND pap.business_group_id=p_business_group_id;
39:
40:

Line 41: l_accrual_category pay_accrual_plans.accrual_category%TYPE := NULL;

37: WHERE pap.accrual_plan_name=p_accrual_plan_name
38: AND pap.business_group_id=p_business_group_id;
39:
40:
41: l_accrual_category pay_accrual_plans.accrual_category%TYPE := NULL;
42: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE := NULL;
43: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE := NULL;
44: l_payroll_id per_assignments_f.payroll_id%TYPE := NULL;
45: l_assignment_number per_assignments_f.assignment_number%TYPE := NULL;

Line 42: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE := NULL;

38: AND pap.business_group_id=p_business_group_id;
39:
40:
41: l_accrual_category pay_accrual_plans.accrual_category%TYPE := NULL;
42: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE := NULL;
43: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE := NULL;
44: l_payroll_id per_assignments_f.payroll_id%TYPE := NULL;
45: l_assignment_number per_assignments_f.assignment_number%TYPE := NULL;
46: l_assignment_id per_assignments_f.assignment_id%TYPE := NULL;

Line 43: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE := NULL;

39:
40:
41: l_accrual_category pay_accrual_plans.accrual_category%TYPE := NULL;
42: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE := NULL;
43: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE := NULL;
44: l_payroll_id per_assignments_f.payroll_id%TYPE := NULL;
45: l_assignment_number per_assignments_f.assignment_number%TYPE := NULL;
46: l_assignment_id per_assignments_f.assignment_id%TYPE := NULL;
47: l_business_group_id per_assignments_f.business_group_id%TYPE := NULL;

Line 159: FROM PAY_ACCRUAL_PLANS PAP,

155: /* -------------------- New Query for Acc plan for an Emp --------------------*/
156:
157: CURSOR acc_plan_cur IS
158: SELECT PAP.ACCRUAL_PLAN_NAME
159: FROM PAY_ACCRUAL_PLANS PAP,
160: PAY_ELEMENT_TYPES_F PETF,
161: HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV,
162: PAY_NET_CALCULATION_RULES PNC,
163: PAY_INPUT_VALUES_F PIV

Line 181: PAY_ACCRUAL_PLANS PAP1

177: FROM PAY_ELEMENT_TYPES_F PETF1,
178: PAY_ELEMENT_CLASSIFICATIONS PEC,
179: PAY_ELEMENT_ENTRIES_F PEEF,
180: PAY_ELEMENT_LINKS_F PELF,
181: PAY_ACCRUAL_PLANS PAP1
182: WHERE
183: PEEF.ASSIGNMENT_ID = p_assignment_id
184: AND PETF1.CLASSIFICATION_ID=PEC.CLASSIFICATION_ID
185: -- AND UPPER(PEC.CLASSIFICATION_NAME) LIKE UPPER('PTO Accrual%')

Line 295: ,PAY_ACCRUAL_PLANS pap

291: Cursor do_accrual_cur is
292: SELECT hours
293: FROM hxt_pay_element_types_f_ddf_v eltv
294: ,pay_element_types_f elt
295: ,PAY_ACCRUAL_PLANS pap
296: ,PAY_NET_CALCULATION_RULES net
297: ,PAY_INPUT_VALUES_F piv
298: ,hxt_sum_hours_worked sm
299: ,per_assignments_f asm

Line 321: PAY_ACCRUAL_PLANS PAP1

317: FROM PAY_ELEMENT_TYPES_F PETF1,
318: PAY_ELEMENT_CLASSIFICATIONS PEC,
319: PAY_ELEMENT_ENTRIES_F PEEF,
320: PAY_ELEMENT_LINKS_F PELF,
321: PAY_ACCRUAL_PLANS PAP1
322: WHERE PEEF.ASSIGNMENT_ID = sm.assignment_id
323: AND PETF1.CLASSIFICATION_ID=PEC.CLASSIFICATION_ID
324: -- AND UPPER(PEC.CLASSIFICATION_NAME) LIKE UPPER('PTO Accrual%')
325: AND PETF1.ELEMENT_TYPE_ID=PELF.ELEMENT_TYPE_ID

Line 338: ,PAY_ACCRUAL_PLANS pap

334: CURSOR accrual_cur(p_date_worked hxt_sum_hours_worked.date_worked%TYPE) IS
335: SELECT distinct pap.accrual_plan_name
336: FROM hxt_pay_element_types_f_ddf_v eltv
337: ,pay_element_types_f elt
338: ,PAY_ACCRUAL_PLANS pap
339: ,PAY_NET_CALCULATION_RULES net
340: ,PAY_INPUT_VALUES_F piv
341: ,hxt_sum_hours_worked sm
342: ,per_assignments_f asm

Line 371: ,PAY_ACCRUAL_PLANS PAP1

367: FROM PAY_ELEMENT_TYPES_F PETF1
368: ,PAY_ELEMENT_CLASSIFICATIONS PEC
369: ,PAY_ELEMENT_ENTRIES_F PEEF
370: ,PAY_ELEMENT_LINKS_F PELF
371: ,PAY_ACCRUAL_PLANS PAP1
372: WHERE PEEF.ASSIGNMENT_ID = sm.assignment_id
373: AND PETF1.CLASSIFICATION_ID=PEC.CLASSIFICATION_ID
374: -- AND UPPER(PEC.CLASSIFICATION_NAME) LIKE UPPER('PTO Accrual%')
375: AND PETF1.ELEMENT_TYPE_ID=PELF.ELEMENT_TYPE_ID

Line 388: ,PAY_ACCRUAL_PLANS pap

384: Cursor on_timecard_cur(p_accrual_plan_name VARCHAR2) is
385: SELECT sum(sm.hours*(-1)*(net.add_or_subtract))
386: FROM hxt_pay_element_types_f_ddf_v eltv
387: ,pay_element_types_f elt
388: ,PAY_ACCRUAL_PLANS pap
389: ,PAY_NET_CALCULATION_RULES net
390: ,PAY_INPUT_VALUES_F piv
391: ,hxt_sum_hours_worked sm
392: ,per_assignments_f asm

Line 432: ,PAY_ACCRUAL_PLANS pap

428: cursor get_retro_total(p_accrual_plan_name VARCHAR2,p_batch_id number) is
429: SELECT nvl(sum(det.hours*(-1)*(net.add_or_subtract)),0)
430: FROM hxt_pay_element_types_f_ddf_v eltv
431: ,pay_element_types_f elt
432: ,PAY_ACCRUAL_PLANS pap
433: ,PAY_NET_CALCULATION_RULES net
434: ,PAY_INPUT_VALUES_F piv
435: ,hxt_det_hours_worked_f det
436: ,per_assignments_f asm

Line 457: ,PAY_ACCRUAL_PLANS pap

453: cursor get_org_total(p_accrual_plan_name VARCHAR2) is
454: SELECT nvl(sum(det.hours*(-1)*(net.add_or_subtract)),0)
455: FROM hxt_pay_element_types_f_ddf_v eltv
456: ,pay_element_types_f elt
457: ,PAY_ACCRUAL_PLANS pap
458: ,PAY_NET_CALCULATION_RULES net
459: ,PAY_INPUT_VALUES_F piv
460: ,hxt_det_hours_worked_f det
461: ,per_assignments_f asm