APPS.PAY_NO_ARCHIVE_RSEA dependencies on PAY_PAYROLL_ACTIONS

Line 45: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

41: p_parameter_string IN VARCHAR2
42: ,p_token IN VARCHAR2
43: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
44: IS
45: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
46: l_start_pos NUMBER;
47: l_delimiter VARCHAR2(1):=' ';
48: l_proc VARCHAR2(40):= g_package||' get parameter ';
49: BEGIN

Line 105: FROM pay_payroll_actions

101: -- ,PAY_NO_ARCHIVE_RSEA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
102: ,PAY_NO_ARCHIVE_RSEA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
103: ,effective_date
104: ,business_group_id
105: FROM pay_payroll_actions
106: WHERE payroll_action_id = p_payroll_action_id;
107: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
108: --
109: BEGIN

Line 337: FROM pay_payroll_actions ppa

333: l_canonical_end_date DATE)
334: IS
335: SELECT
336: DISTINCT act.assignment_id assignment_id
337: FROM pay_payroll_actions ppa
338: ,pay_payroll_actions appa
339: ,pay_payroll_actions appa2
340: ,pay_assignment_actions act
341: ,pay_assignment_actions act1

Line 338: ,pay_payroll_actions appa

334: IS
335: SELECT
336: DISTINCT act.assignment_id assignment_id
337: FROM pay_payroll_actions ppa
338: ,pay_payroll_actions appa
339: ,pay_payroll_actions appa2
340: ,pay_assignment_actions act
341: ,pay_assignment_actions act1
342: ,pay_action_interlocks pai

Line 339: ,pay_payroll_actions appa2

335: SELECT
336: DISTINCT act.assignment_id assignment_id
337: FROM pay_payroll_actions ppa
338: ,pay_payroll_actions appa
339: ,pay_payroll_actions appa2
340: ,pay_assignment_actions act
341: ,pay_assignment_actions act1
342: ,pay_action_interlocks pai
343: ,per_all_assignments_f as1

Line 397: FROM pay_payroll_actions ppa

393: l_canonical_start_date DATE,
394: l_canonical_end_date DATE)
395: IS
396: SELECT DISTINCT act.assignment_id assignment_id
397: FROM pay_payroll_actions ppa
398: ,pay_payroll_actions appa
399: ,pay_payroll_actions appa2
400: ,pay_assignment_actions act
401: ,pay_assignment_actions act1

Line 398: ,pay_payroll_actions appa

394: l_canonical_end_date DATE)
395: IS
396: SELECT DISTINCT act.assignment_id assignment_id
397: FROM pay_payroll_actions ppa
398: ,pay_payroll_actions appa
399: ,pay_payroll_actions appa2
400: ,pay_assignment_actions act
401: ,pay_assignment_actions act1
402: ,pay_action_interlocks pai

Line 399: ,pay_payroll_actions appa2

395: IS
396: SELECT DISTINCT act.assignment_id assignment_id
397: FROM pay_payroll_actions ppa
398: ,pay_payroll_actions appa
399: ,pay_payroll_actions appa2
400: ,pay_assignment_actions act
401: ,pay_assignment_actions act1
402: ,pay_action_interlocks pai
403: ,per_all_assignments_f as1

Line 560: ,pay_payroll_actions ppa

556: END IF;
557:
558: p_sql := 'SELECT DISTINCT person_id
559: FROM per_people_f ppf
560: ,pay_payroll_actions ppa
561: WHERE ppa.payroll_action_id = :payroll_action_id
562: AND ppa.business_group_id = ppf.business_group_id
563: ORDER BY ppf.person_id';
564: