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 829: ,pay_payroll_actions ppa

825: IF l_person_id IS NULL
826: THEN
827: l_string :=
828: 'SELECT DISTINCT person_id FROM per_people_f ppf
829: ,pay_payroll_actions ppa
830: WHERE ppf.business_group_id = ppa.business_group_id
831: AND ppa.payroll_action_id = :payroll_action_id
832: ORDER BY ppf.person_id';
833: ELSE -- l_person_id IS NOT NULL

Line 836: ,pay_payroll_actions ppa

832: ORDER BY ppf.person_id';
833: ELSE -- l_person_id IS NOT NULL
834: l_string :=
835: 'SELECT DISTINCT person_id FROM per_people_f ppf
836: ,pay_payroll_actions ppa
837: WHERE ppf.business_group_id = ppa.business_group_id
838: AND ppa.payroll_action_id = :payroll_action_id
839: AND ppf.person_id = '
840: || l_person_id

Line 953: ,pay_payroll_actions ppa

949: l_string :=
950: 'SELECT DISTINCT person_id
951: FROM per_all_assignments_f paa
952: ,hr_assignment_set_amendments hasa
953: ,pay_payroll_actions ppa
954: WHERE paa.business_group_id = ppa.business_group_id
955: AND ppa.payroll_action_id = :payroll_action_id
956: AND paa.assignment_id = hasa.assignment_id
957: AND NVL(hasa.include_or_exclude,'

Line 3863: -- Delete pay_payroll_actions

3859: debug(l_proc_name, l_proc_step);
3860: debug(SQL%ROWCOUNT || ' pay_population_ranges rows deleted');
3861: END IF;
3862:
3863: -- Delete pay_payroll_actions
3864: l_proc_step := 80;
3865: DELETE FROM pay_payroll_actions
3866: WHERE payroll_action_id = p_pay_action_id;
3867:

Line 3865: DELETE FROM pay_payroll_actions

3861: END IF;
3862:
3863: -- Delete pay_payroll_actions
3864: l_proc_step := 80;
3865: DELETE FROM pay_payroll_actions
3866: WHERE payroll_action_id = p_pay_action_id;
3867:
3868: IF g_debug
3869: THEN

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

3867:
3868: IF g_debug
3869: THEN
3870: debug(l_proc_name, l_proc_step);
3871: debug(SQL%ROWCOUNT || ' pay_payroll_actions rows deleted');
3872: END IF;
3873: END IF; -- End if of l_count = 0 check ...
3874:
3875: */