eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 132: g_assignment_id pay_assignment_actions.assignment_id%TYPE;

128: -- 22 Jul 2008 jalin 7184102 ORDER BY clause should use quarter_start_date instead of b.quarter_start_date
129: --
130:
131: --* GLobal variables (populated in archive_code procedure)
132: g_assignment_id pay_assignment_actions.assignment_id%TYPE;
133: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
134: g_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE;
135: g_archive_message ff_archive_items.value%TYPE := NULL;
136: g_error_in_quarter BOOLEAN := FALSE;

Line 133: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

129: --
130:
131: --* GLobal variables (populated in archive_code procedure)
132: g_assignment_id pay_assignment_actions.assignment_id%TYPE;
133: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
134: g_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE;
135: g_archive_message ff_archive_items.value%TYPE := NULL;
136: g_error_in_quarter BOOLEAN := FALSE;
137: g_business_group_id hr_organization_units.business_group_id%TYPE; -- for submitting the PAYHKCTL report

Line 195: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;

191: p_start_person_id in per_all_people_f.person_id%TYPE,
192: p_end_person_id in per_all_people_f.person_id%TYPE,
193: p_chunk in number)
194: IS
195: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
196: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
197:
198: /* Following variables introduced for Bug No : 2740270 */
199: v_fin_start_date date;

Line 196: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;

192: p_end_person_id in per_all_people_f.person_id%TYPE,
193: p_chunk in number)
194: IS
195: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
196: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
197:
198: /* Following variables introduced for Bug No : 2740270 */
199: v_fin_start_date date;
200: v_fin_end_date date;

Line 214: SELECT pay_assignment_actions_s.NEXTVAL

210: asglist t_assignment_list;
211:
212:
213: CURSOR next_action_id is
214: SELECT pay_assignment_actions_s.NEXTVAL
215: FROM dual;
216:
217: /* Introduced the following cursor get_params for Bug No : 2740270 */
218:

Line 242: pay_assignment_actions pac

238: IS
239: SELECT distinct pac.assignment_id
240: FROM pay_payroll_actions ppa,
241: pay_payrolls_f pay, /* Added for Bug 3916743 - performance fix. */
242: pay_assignment_actions pac
243: WHERE ppa.action_type in ('R','B','I','Q')
244: AND ppa.payroll_action_id = pac.payroll_action_id
245: AND ppa.business_group_id = c_business_group_id
246: AND pac.tax_unit_id = c_legal_entity_id

Line 295: pay_assignment_actions paa

291: (SELECT NULL
292: FROM pay_action_interlocks pai,
293: pay_payroll_actions ppai,
294: pay_payroll_actions ppaa,
295: pay_assignment_actions paa
296: WHERE paa.assignment_id = a.assignment_id
297: AND ppaa.action_type='X'
298: AND ppaa.report_type = 'HK_IR56B_ARCHIVE'
299: AND ppai.action_type='X'

Line 404: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,

400:
401: /* Bug No : 2829320 - Included substr function for address_lines column so that 240 characters are only fetched */
402: /*Bug 2942797 - Removed column chineese_full_name*/
403: CURSOR ir56_Employee_info
404: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
405: c_reporting_year Varchar2 )
406: IS
407: SELECT DISTINCT
408: papf.national_identifier hk_id_card_no,

Line 881: CURSOR max_assign_action_id(c_assignment_id pay_assignment_actions.assignment_id%TYPE,

877: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
878: p_reporting_year IN Varchar2)
879: IS
880:
881: CURSOR max_assign_action_id(c_assignment_id pay_assignment_actions.assignment_id%TYPE,
882: c_reporting_year Varchar2 )
883: IS
884: SELECT paa.assignment_action_id
885: FROM pay_assignment_actions paa

Line 885: FROM pay_assignment_actions paa

881: CURSOR max_assign_action_id(c_assignment_id pay_assignment_actions.assignment_id%TYPE,
882: c_reporting_year Varchar2 )
883: IS
884: SELECT paa.assignment_action_id
885: FROM pay_assignment_actions paa
886: WHERE paa.assignment_id = c_assignment_id
887: and paa.action_sequence = (select max(paa2.action_sequence)
888: from pay_assignment_actions paa2,
889: pay_payroll_actions ppa

Line 888: from pay_assignment_actions paa2,

884: SELECT paa.assignment_action_id
885: FROM pay_assignment_actions paa
886: WHERE paa.assignment_id = c_assignment_id
887: and paa.action_sequence = (select max(paa2.action_sequence)
888: from pay_assignment_actions paa2,
889: pay_payroll_actions ppa
890: where paa2.assignment_id = c_assignment_id
891: and ppa.payroll_action_id = paa2.payroll_action_id
892: and paa2.action_status = 'C'

Line 990: (c_assignment_id IN pay_assignment_actions.assignment_id%TYPE,

986:
987: /* Bug 7184102 Added ORDER BY clause into cursor quarters_info */
988:
989: CURSOR quarters_info
990: (c_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
991: c_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
992: IS
993: SELECT b.assignment_id assignment_id,
994: b.SOURCE_ID source_id,

Line 991: c_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)

987: /* Bug 7184102 Added ORDER BY clause into cursor quarters_info */
988:
989: CURSOR quarters_info
990: (c_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
991: c_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
992: IS
993: SELECT b.assignment_id assignment_id,
994: b.SOURCE_ID source_id,
995: b.QUARTERS_ADDRESS quarters_address,

Line 1188: CURSOR os_info (c_assignment_id in pay_assignment_actions.assignment_id%TYPE)

1184: p_reporting_year IN Varchar2)
1185: IS
1186: v_loop_cnt number := 0;
1187:
1188: CURSOR os_info (c_assignment_id in pay_assignment_actions.assignment_id%TYPE)
1189: IS
1190: SELECT *
1191: FROM pay_hk_ir56_overseas_concern_v
1192: WHERE assignment_id = c_assignment_id

Line 1260: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,

1256:
1257: employer_rec ir56_employer_info%ROWTYPE;
1258:
1259: CURSOR ir56_Employee_info
1260: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
1261: c_reporting_year Varchar2 )
1262: IS
1263: SELECT DISTINCT
1264: papf.national_identifier hk_id_card_no,

Line 1485: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,

1481: -- different parameters are required.
1482: ------------------------------------------------------------------------
1483:
1484: PROCEDURE archive_code
1485: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1486: p_effective_date in date)
1487: IS
1488: v_person_id per_all_people_f.person_id%TYPE;
1489: v_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 1491: v_legal_entity_id pay_assignment_actions.tax_unit_id%TYPE;

1487: IS
1488: v_person_id per_all_people_f.person_id%TYPE;
1489: v_assignment_id per_all_assignments_f.assignment_id%TYPE;
1490: v_business_group_id hr_organization_units.business_group_id%TYPE;
1491: v_legal_entity_id pay_assignment_actions.tax_unit_id%TYPE;
1492: v_reporting_year varchar2(4);
1493: v_archive_date pay_payroll_actions.effective_date%TYPE;
1494:
1495: CURSOR archive_parameters

Line 1496: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

1492: v_reporting_year varchar2(4);
1493: v_archive_date pay_payroll_actions.effective_date%TYPE;
1494:
1495: CURSOR archive_parameters
1496: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1497: IS
1498: SELECT paa.person_id,
1499: pac.assignment_id,
1500: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),

Line 1505: pay_assignment_actions pac,

1501: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1502: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1503: effective_date
1504: FROM pay_payroll_actions ppa,
1505: pay_assignment_actions pac,
1506: per_assignments_f paa
1507: WHERE pac.assignment_action_id = c_assignment_action_id
1508: AND ppa.payroll_action_id = pac.payroll_action_id
1509: AND paa.assignment_id = pac.assignment_id;

Line 1565: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,

1561: ---------------------------------------------------------------------------
1562:
1563: PROCEDURE archive_item
1564: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE,
1565: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1566: p_archive_value IN ff_archive_items.value%TYPE)
1567: IS
1568: v_user_entity_id ff_user_entities.user_entity_id%TYPE;
1569: v_archive_item_id ff_archive_items.archive_item_id%TYPE;