APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_ACTION_INFORMATION

Line 507: from pay_action_information

503:
504: /* Cursor to get date earned for a payroll */
505: cursor c_get_date_earned(cp_assignment_action_id in number) is
506: select max(effective_date)
507: from pay_action_information
508: where action_context_id = cp_assignment_action_id
509: and action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION';
510:
511: /* Cursor to get time period for a payroll */

Line 523: from pay_action_information

519:
520: /* Cursor to check whether archive data exists or not*/
521: cursor c_get_archived is
522: select count(*)
523: from pay_action_information
524: where action_context_id = p_assignment_action_id
525: and action_information_category ='GB ELEMENT PAYSLIP INFO';
526:
527: lv_return_flag VARCHAR2(1);

Line 612: from pay_action_information

608:
609: /* Cursor to get date earned for a payroll */
610: cursor c_get_date_earned(cp_assignment_action_id in number) is
611: select max(effective_date)
612: from pay_action_information
613: where action_context_id = cp_assignment_action_id
614: and action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION';
615:
616: /* Cursor to get time period for a payroll */

Line 628: from pay_action_information

624:
625: /* Cursor to check whether archive data exists or not*/
626: cursor c_get_archived is
627: select count(*)
628: from pay_action_information
629: where action_context_id = p_assignment_action_id
630: and action_information_category = 'EMEA ELEMENT INFO'
631: and action_information3 in ('E','D');
632:

Line 718: from pay_action_information

714:
715: /* Cursor to get date earned for a payroll */
716: cursor c_get_date_earned(cp_assignment_action_id in number) is
717: select max(effective_date)
718: from pay_action_information
719: where action_context_id = cp_assignment_action_id
720: and action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION';
721:
722: /* Cursor to get time period for a payroll */

Line 734: from pay_action_information

730:
731: /* Cursor to check whether archive data exists or not*/
732: cursor c_get_archived is
733: select count(*)
734: from pay_action_information
735: where action_context_id = p_assignment_action_id
736: and action_information_category = 'EMEA ELEMENT INFO'
737: and action_information3 in ('E','D');
738:

Line 2338: pay_action_information pai

2334:
2335: cursor c_get_terminate_date is
2336: select actual_termination_date, pai.action_information16
2337: from per_periods_of_service pps,
2338: pay_action_information pai
2339: where pps.person_id = p_person_id
2340: and pai.action_context_id = p_action_context_id
2341: and pai.action_information_category = 'EMPLOYEE DETAILS'
2342: /* and fnd_date.canonical_to_date(pai.action_information11) = pps.date_start;*/

Line 2519: -- California OT Enhancement Started Populating pay_action_information

2515: END get_full_jurisdiction_name;
2516:
2517: -- This Function will be called from View Definition of
2518: -- PAY_EMP_NET_DIST_ACTION_INFO_V
2519: -- California OT Enhancement Started Populating pay_action_information
2520: -- Table with Account Details for Payment Method Check
2521: -- We need to hide those Details in Self Service Payslip
2522:
2523: FUNCTION get_netpaydistr_segment(p_business_grp_id IN NUMBER