APPS.PAY_DK_ARCHIVE_EIN dependencies on PAY_PAYROLL_ACTIONS

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

57: p_parameter_string IN VARCHAR2
58: ,p_token IN VARCHAR2
59: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
60: IS
61: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
62: l_start_pos NUMBER;
63: l_delimiter VARCHAR2(1):=' ';
64: l_proc VARCHAR2(40):= g_package||' get parameter ';
65: BEGIN

Line 121: FROM pay_payroll_actions

117: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
118: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
119: ,effective_date
120: ,business_group_id
121: FROM pay_payroll_actions
122: WHERE payroll_action_id = p_payroll_action_id;
123:
124: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
125: --

Line 230: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id AND ppa.business_group_id = ppf.business_group_id ORDER BY ppf.person_id';

226: IF g_debug THEN
227: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
228: END IF;
229:
230: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id AND ppa.business_group_id = ppf.business_group_id ORDER BY ppf.person_id';
231:
232: -- fnd_file.put_line(fnd_file.log,'Range Code 2');
233:
234: g_legal_employer_id := NULL ;

Line 592: FROM pay_payroll_actions ppa

588: SELECT as1.person_id person_id,
589: act.assignment_id assignment_id,
590: act.assignment_action_id run_action_id,
591: act1.assignment_action_id prepaid_action_id
592: FROM pay_payroll_actions ppa
593: ,pay_payroll_actions appa
594: ,pay_payroll_actions appa2
595: ,pay_assignment_actions act
596: ,pay_assignment_actions act1

Line 593: ,pay_payroll_actions appa

589: act.assignment_id assignment_id,
590: act.assignment_action_id run_action_id,
591: act1.assignment_action_id prepaid_action_id
592: FROM pay_payroll_actions ppa
593: ,pay_payroll_actions appa
594: ,pay_payroll_actions appa2
595: ,pay_assignment_actions act
596: ,pay_assignment_actions act1
597: ,pay_action_interlocks pai

Line 594: ,pay_payroll_actions appa2

590: act.assignment_action_id run_action_id,
591: act1.assignment_action_id prepaid_action_id
592: FROM pay_payroll_actions ppa
593: ,pay_payroll_actions appa
594: ,pay_payroll_actions appa2
595: ,pay_assignment_actions act
596: ,pay_assignment_actions act1
597: ,pay_action_interlocks pai
598: ,per_all_assignments_f as1

Line 924: from pay_assignment_actions pac, pay_payroll_actions ppa

920: lr_Get_Defined_Balance_Id csr_Get_Defined_Balance_Id%rowtype;
921:
922: CURSOR csr_asg_action_id(assg_id NUMBER, pid NUMBER, tid NUMBER, le_id NUMBER) IS
923: select pac.ASSIGNMENT_ACTION_ID id
924: from pay_assignment_actions pac, pay_payroll_actions ppa
925: where ppa.action_type IN ('R','Q')
926: and pac.payroll_action_id = ppa.payroll_action_id
927: and pac.assignment_id= assg_id
928: and ppa.payroll_id=pid

Line 1575: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

1571: RAISE;
1572: END ARCHIVE_CODE;
1573:
1574: PROCEDURE DEINITIALIZATION_CODE
1575: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
1576:
1577: /* Cursors to fetch data for record numbering*/
1578:
1579: CURSOR csr_all_rec ( p_payroll_action_id NUMBER) IS