APPS.PAY_EOSURVEY_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 626: FROM pay_payroll_actions ppa

622:
623: CURSOR c_leg_param(l_pact_id pay_assignment_actions.payroll_action_id%type)
624: IS
625: SELECT ppa.legislative_parameters,ppa.start_date,ppa.effective_date
626: FROM pay_payroll_actions ppa
627: WHERE ppa.payroll_action_id =l_pact_id;
628:
629: /* This cursor picks up the defined balance_id for the new balance
630: EO Regular Salary YTD */

Line 662: CURSOR c_fte_asgn(l_pactid pay_payroll_actions.payroll_action_id%type,

658: /* This cursor picks up all the assignment actions that has been
659: inserted in pay_assignment_Actions for a specific chunk and pactid.
660: It also picks up the person_id stored in serial_number. */
661:
662: CURSOR c_fte_asgn(l_pactid pay_payroll_actions.payroll_action_id%type,
663: l_chunk pay_assignment_actions.chunk_number%type)
664: IS
665: SELECT assignment_action_id,
666: assignment_id,

Line 767: l_leg_param pay_payroll_actions.legislative_parameters%type;

763: l_est_entity_id number;
764: l_hierarchy_version_id number;
765: l_min_hours number;
766: l_defined_balance_id number;
767: l_leg_param pay_payroll_actions.legislative_parameters%type;
768: l_period_end date;
769: l_period_start date;
770: l_est_count number;
771: l_max_asact_id pay_assignment_Actions.assignment_action_id%type;

Line 1202: pay_payroll_actions ppa

1198: IS
1199: SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1200: paa.assignment_action_id),16))
1201: FROM pay_assignment_actions paa,
1202: pay_payroll_actions ppa
1203: WHERE paa.assignment_id = c_assignment_id
1204: AND ppa.payroll_action_id = paa.payroll_action_id
1205: AND ppa.effective_date <= c_period_end
1206: AND ppa.action_type in ('R', 'Q', 'I');