APPS.PQP_BUDGET_MAINTENANCE dependencies on PAY_PAYROLL_ACTIONS

Line 30: g_parameter_list pay_payroll_actions.legislative_parameters%TYPE;

26: -- global Variables for concurrent program
27: g_person_id NUMBER;
28: g_formula_id NUMBER;
29: g_assignment_set_id NUMBER;
30: g_parameter_list pay_payroll_actions.legislative_parameters%TYPE;
31: g_uom VARCHAR2(30);
32: g_action VARCHAR2(30);
33: g_effective_date DATE;
34: g_payroll_id NUMBER;

Line 444: FROM pay_payroll_actions

440: --
441: CURSOR csr_get_param_string
442: IS
443: SELECT legislative_parameters
444: FROM pay_payroll_actions
445: WHERE payroll_action_id = p_pay_action_id;
446:
447: l_proc_step NUMBER(38, 10) := 0;
448: l_proc_name VARCHAR2(61)

Line 450: l_parameter_list pay_payroll_actions.legislative_parameters%TYPE;

446:
447: l_proc_step NUMBER(38, 10) := 0;
448: l_proc_name VARCHAR2(61)
449: := g_package_name || 'get_parameter_list';
450: l_parameter_list pay_payroll_actions.legislative_parameters%TYPE;
451: --
452: BEGIN
453: --
454: IF g_debug

Line 511: l_token_val pay_payroll_actions.legislative_parameters%TYPE;

507: l_proc_step NUMBER(38, 10) := 0;
508: l_proc_name VARCHAR2(61) := g_package_name || 'get_parameter_value';
509: l_start_ptr NUMBER;
510: l_end_ptr NUMBER;
511: l_token_val pay_payroll_actions.legislative_parameters%TYPE;
512: l_par_value pay_payroll_actions.legislative_parameters%TYPE;
513: --
514: BEGIN
515: --

Line 512: l_par_value pay_payroll_actions.legislative_parameters%TYPE;

508: l_proc_name VARCHAR2(61) := g_package_name || 'get_parameter_value';
509: l_start_ptr NUMBER;
510: l_end_ptr NUMBER;
511: l_token_val pay_payroll_actions.legislative_parameters%TYPE;
512: l_par_value pay_payroll_actions.legislative_parameters%TYPE;
513: --
514: BEGIN
515: --
516: IF g_debug

Line 840: ,pay_payroll_actions ppa

836: IF l_person_id IS NULL
837: THEN
838: l_string :=
839: 'SELECT DISTINCT person_id FROM per_people_f ppf
840: ,pay_payroll_actions ppa
841: WHERE ppf.business_group_id = ppa.business_group_id
842: AND ppa.payroll_action_id = :payroll_action_id
843: ORDER BY ppf.person_id';
844: ELSE -- l_person_id IS NOT NULL

Line 847: ,pay_payroll_actions ppa

843: ORDER BY ppf.person_id';
844: ELSE -- l_person_id IS NOT NULL
845: l_string :=
846: 'SELECT DISTINCT person_id FROM per_people_f ppf
847: ,pay_payroll_actions ppa
848: WHERE ppf.business_group_id = ppa.business_group_id
849: AND ppa.payroll_action_id = :payroll_action_id
850: AND ppf.person_id = '
851: || l_person_id

Line 964: ,pay_payroll_actions ppa

960: l_string :=
961: 'SELECT DISTINCT person_id
962: FROM per_all_assignments_f paa
963: ,hr_assignment_set_amendments hasa
964: ,pay_payroll_actions ppa
965: WHERE paa.business_group_id = ppa.business_group_id
966: AND ppa.payroll_action_id = :payroll_action_id
967: AND paa.assignment_id = hasa.assignment_id
968: AND NVL(hasa.include_or_exclude,'

Line 3905: -- Delete pay_payroll_actions

3901: debug(l_proc_name, l_proc_step);
3902: debug(SQL%ROWCOUNT || ' pay_population_ranges rows deleted');
3903: END IF;
3904:
3905: -- Delete pay_payroll_actions
3906: l_proc_step := 80;
3907: DELETE FROM pay_payroll_actions
3908: WHERE payroll_action_id = p_pay_action_id;
3909:

Line 3907: DELETE FROM pay_payroll_actions

3903: END IF;
3904:
3905: -- Delete pay_payroll_actions
3906: l_proc_step := 80;
3907: DELETE FROM pay_payroll_actions
3908: WHERE payroll_action_id = p_pay_action_id;
3909:
3910: IF g_debug
3911: THEN

Line 3913: debug(SQL%ROWCOUNT || ' pay_payroll_actions rows deleted');

3909:
3910: IF g_debug
3911: THEN
3912: debug(l_proc_name, l_proc_step);
3913: debug(SQL%ROWCOUNT || ' pay_payroll_actions rows deleted');
3914: END IF;
3915: END IF; -- End if of l_count = 0 check ...
3916:
3917: */