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_CN_SOE dependencies on PAY_ACCRUAL_PLANS

Line 513: FROM pay_accrual_plans pap

509: ,ppa.payroll_id
510: ,pap.business_group_id
511: ,pap.accrual_plan_id
512: ,paa.assignment_id
513: FROM pay_accrual_plans pap
514: ,pay_element_types_f pet
515: ,pay_element_links_f pel
516: ,pay_element_entries_f pee
517: ,pay_assignment_actions paa

Line 543: FROM pay_accrual_plans pap

539: ,ppa.payroll_id
540: ,pap.business_group_id
541: ,pap.accrual_plan_id
542: ,paa.assignment_id
543: FROM pay_accrual_plans pap
544: ,pay_accrual_plans_tl paptl
545: ,pay_element_types_f pet
546: ,pay_element_links_f pel
547: ,pay_element_entries_f pee

Line 544: ,pay_accrual_plans_tl paptl

540: ,pap.business_group_id
541: ,pap.accrual_plan_id
542: ,paa.assignment_id
543: FROM pay_accrual_plans pap
544: ,pay_accrual_plans_tl paptl
545: ,pay_element_types_f pet
546: ,pay_element_links_f pel
547: ,pay_element_entries_f pee
548: ,pay_assignment_actions paa

Line 581: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

577: SELECT MAX(locked_action_id)
578: FROM pay_action_interlocks
579: WHERE locking_action_id = p_assignment_action_id;
580:
581: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
582: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
583: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
584: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
585: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 582: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

578: FROM pay_action_interlocks
579: WHERE locking_action_id = p_assignment_action_id;
580:
581: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
582: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
583: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
584: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
585: l_business_group_id per_business_groups.business_group_id%TYPE;
586: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

Line 583: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;

579: WHERE locking_action_id = p_assignment_action_id;
580:
581: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
582: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
583: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
584: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
585: l_business_group_id per_business_groups.business_group_id%TYPE;
586: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
587: l_assignment_id per_assignments_f.assignment_id%TYPE;

Line 586: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

582: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
583: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
584: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
585: l_business_group_id per_business_groups.business_group_id%TYPE;
586: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
587: l_assignment_id per_assignments_f.assignment_id%TYPE;
588: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
589: l_annual_leave_balance NUMBER;
590: l_ovn NUMBER;