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

Line 116: (c_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE)

112: (p_accrual_plan_id IN NUMBER)
113: IS
114:
115: CURSOR csr_fw_plan_details
116: (c_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE)
117: IS
118: SELECT pap.accrual_plan_id plan_id
119: ,pap.accrual_category accrual_category
120: ,pap.information3 information3

Line 126: FROM pay_accrual_plans pap

122: ,pap_fw.accrual_plan_id fw_plan_id
123: ,pap_fw.accrual_category fw_accrual_category
124: ,pap_fw.information3 fw_information3
125: ,pap_fw.information3 fw_information4
126: FROM pay_accrual_plans pap
127: ,pay_accrual_plans pap_fw
128: where pap.accrual_plan_id = c_accrual_plan_id
129: AND pap.business_group_id = pap_fw.business_group_id(+)
130: AND pap.accrual_category = pap_fw.accrual_category(+)

Line 127: ,pay_accrual_plans pap_fw

123: ,pap_fw.accrual_category fw_accrual_category
124: ,pap_fw.information3 fw_information3
125: ,pap_fw.information3 fw_information4
126: FROM pay_accrual_plans pap
127: ,pay_accrual_plans pap_fw
128: where pap.accrual_plan_id = c_accrual_plan_id
129: AND pap.business_group_id = pap_fw.business_group_id(+)
130: AND pap.accrual_category = pap_fw.accrual_category(+)
131: AND pap_fw.information3(+) = 'Y'

Line 641: FROM pay_accrual_plans

637:
638: CURSOR c_get_co_formula (v_accrual_plan_id NUMBER)
639: IS
640: SELECT co_formula_id
641: FROM pay_accrual_plans
642: WHERE accrual_plan_id = v_accrual_plan_id;
643:
644: CURSOR c_get_oth_adj_type(v_accrual_plan_id NUMBER) IS
645: SELECT information2

Line 646: FROM pay_accrual_plans

642: WHERE accrual_plan_id = v_accrual_plan_id;
643:
644: CURSOR c_get_oth_adj_type(v_accrual_plan_id NUMBER) IS
645: SELECT information2
646: FROM pay_accrual_plans
647: WHERE accrual_plan_id = v_accrual_plan_id;
648:
649: CURSOR c_get_end_date(v_assignment_id NUMBER)
650: IS

Line 1197: FROM pay_accrual_plans pap,

1193: CURSOR csr_get_accrual_plan_id(p_assignment_id NUMBER
1194: ,p_effective_date DATE
1195: ,p_plan_category VARCHAR2) IS
1196: SELECT pap.accrual_plan_id
1197: FROM pay_accrual_plans pap,
1198: pay_element_entries_f pee,
1199: pay_element_links_f pel,
1200: pay_element_types_f pet
1201: WHERE pee.assignment_id = p_assignment_id

Line 1485: from pay_accrual_plans

1481: ---------------------------------------------
1482:
1483: cursor c_get_co_formula (v_accrual_plan_id number) is
1484: select co_formula_id
1485: from pay_accrual_plans
1486: where accrual_plan_id = v_accrual_plan_id;
1487:
1488: -- Start of Bug 9444169
1489: cursor c_get_oth_adj_type(v_accrual_plan_id number) is

Line 1491: from pay_accrual_plans

1487:
1488: -- Start of Bug 9444169
1489: cursor c_get_oth_adj_type(v_accrual_plan_id number) is
1490: select information2
1491: from pay_accrual_plans
1492: where accrual_plan_id = v_accrual_plan_id;
1493: -- End of Bug 9444169
1494:
1495: l_ppl_ent number := 0; -- 10212532

Line 1765: FROM pay_accrual_plans pap,

1761: CURSOR csr_annual_leave_accrual_plan(c_business_group_id IN NUMBER
1762: ,c_calculation_date IN DATE
1763: ,c_assignment_id IN NUMBER) IS
1764: SELECT pap.accrual_plan_id
1765: FROM pay_accrual_plans pap,
1766: pay_element_entries_f pee,
1767: pay_element_links_f pel,
1768: pay_element_types_f pet
1769: WHERE pel.element_link_id = pee.element_link_id

Line 1828: pay_accrual_plans pap,

1824: SELECT NVL(TO_DATE(pev.screen_entry_value,'YYYY/MM/DD HH24:MI:SS'),pps.date_start)
1825: FROM pay_element_entries_f pee,
1826: pay_element_entry_values_f pev,
1827: pay_input_values_f piv,
1828: pay_accrual_plans pap,
1829: hr_lookups hrl,
1830: per_assignments_f asg,
1831: per_periods_of_service pps
1832: WHERE pev.element_entry_id = pee.element_entry_id

Line 2463: pay_accrual_plans pap

2459: ,v_end_date date ) is
2460: select
2461: sum(nvl(fnd_number.canonical_to_number(pev1.screen_entry_value),0))
2462: from
2463: pay_accrual_plans pap
2464: ,pay_element_types_f pet
2465: ,pay_element_links_f pel
2466: ,pay_input_values_f piv1
2467: ,pay_input_values_f piv2

Line 2643: from pay_accrual_plans pap

2639: -- find plan name
2640: cursor c_plan_name ( v_business_group_id number
2641: ,v_entry_value varchar2 ) is
2642: select 1
2643: from pay_accrual_plans pap
2644: where pap.business_group_id = v_business_group_id
2645: and pap.accrual_plan_name = v_entry_value;
2646:
2647: begin

Line 2690: from pay_accrual_plans pap,

2686: ,v_assignment_id number
2687: ,v_calculation_date date )
2688: is
2689: select min(PEE.EFFECTIVE_START_DATE)
2690: from pay_accrual_plans pap,
2691: pay_element_types_f pet,
2692: pay_element_links_f pel,
2693: pay_element_entries_f pee,
2694: per_assignments_f paf,