DBA Data[Home] [Help]

APPS.PAY_FR_DADS_ESTAB_COMP dependencies on HR_LOOKUPS

Line 118: l_error_type hr_lookups.meaning%type;

114: l_cre_nic varchar2(7) ;
115: l_cre_media hr_organization_information.org_information1%TYPE ;
116: l_address_to_use hr_organization_information.org_information2%TYPE ;
117: l_value fnd_new_messages.message_text%type;
118: l_error_type hr_lookups.meaning%type;
119: l_error hr_lookups.meaning%type;
120: l_warning hr_lookups.meaning%type;
121: l_cre_estab_name hr_all_organization_units_tl.name%TYPE;
122: l_location_name hr_locations_all_tl.location_code%TYPE;

Line 119: l_error hr_lookups.meaning%type;

115: l_cre_media hr_organization_information.org_information1%TYPE ;
116: l_address_to_use hr_organization_information.org_information2%TYPE ;
117: l_value fnd_new_messages.message_text%type;
118: l_error_type hr_lookups.meaning%type;
119: l_error hr_lookups.meaning%type;
120: l_warning hr_lookups.meaning%type;
121: l_cre_estab_name hr_all_organization_units_tl.name%TYPE;
122: l_location_name hr_locations_all_tl.location_code%TYPE;
123: --

Line 120: l_warning hr_lookups.meaning%type;

116: l_address_to_use hr_organization_information.org_information2%TYPE ;
117: l_value fnd_new_messages.message_text%type;
118: l_error_type hr_lookups.meaning%type;
119: l_error hr_lookups.meaning%type;
120: l_warning hr_lookups.meaning%type;
121: l_cre_estab_name hr_all_organization_units_tl.name%TYPE;
122: l_location_name hr_locations_all_tl.location_code%TYPE;
123: --
124: Cursor csr_get_S10_G00 is

Line 792: l_error_type hr_lookups.meaning%type;

788: l_address_to_use hr_organization_information.org_information4%TYPE ;
789: l_count number;
790: l_name hr_all_organization_units_tl.name%TYPE ;
791: l_value fnd_new_messages.message_text%type;
792: l_error_type hr_lookups.meaning%type;
793: l_error hr_lookups.meaning%type;
794: l_warning hr_lookups.meaning%type;
795: --
796: cursor csr_get_S10_G01 is

Line 793: l_error hr_lookups.meaning%type;

789: l_count number;
790: l_name hr_all_organization_units_tl.name%TYPE ;
791: l_value fnd_new_messages.message_text%type;
792: l_error_type hr_lookups.meaning%type;
793: l_error hr_lookups.meaning%type;
794: l_warning hr_lookups.meaning%type;
795: --
796: cursor csr_get_S10_G01 is
797: select hoi_issue_estab_cre.org_information1 person_g01,

Line 794: l_warning hr_lookups.meaning%type;

790: l_name hr_all_organization_units_tl.name%TYPE ;
791: l_value fnd_new_messages.message_text%type;
792: l_error_type hr_lookups.meaning%type;
793: l_error hr_lookups.meaning%type;
794: l_warning hr_lookups.meaning%type;
795: --
796: cursor csr_get_S10_G01 is
797: select hoi_issue_estab_cre.org_information1 person_g01,
798: hou_issue_estab_tl.name name_issue_estab,

Line 983: l_error_type hr_lookups.meaning%type;

979: l_periodicity_code_test varchar2(5);
980: l_hq_estab_id hr_organization_information.organization_id%TYPE;
981: l_fisc_estab_id hr_organization_information.organization_id%TYPE;
982: l_value fnd_new_messages.message_text%type;
983: l_error_type hr_lookups.meaning%type;
984: l_error hr_lookups.meaning%type;
985: l_warning hr_lookups.meaning%type;
986: --
987: -- Cursor for fetching S20 information

Line 984: l_error hr_lookups.meaning%type;

980: l_hq_estab_id hr_organization_information.organization_id%TYPE;
981: l_fisc_estab_id hr_organization_information.organization_id%TYPE;
982: l_value fnd_new_messages.message_text%type;
983: l_error_type hr_lookups.meaning%type;
984: l_error hr_lookups.meaning%type;
985: l_warning hr_lookups.meaning%type;
986: --
987: -- Cursor for fetching S20 information
988: cursor csr_S20_G01_00(p_company_id number,

Line 985: l_warning hr_lookups.meaning%type;

981: l_fisc_estab_id hr_organization_information.organization_id%TYPE;
982: l_value fnd_new_messages.message_text%type;
983: l_error_type hr_lookups.meaning%type;
984: l_error hr_lookups.meaning%type;
985: l_warning hr_lookups.meaning%type;
986: --
987: -- Cursor for fetching S20 information
988: cursor csr_S20_G01_00(p_company_id number,
989: p_cre_estab_id_chr varchar2) is

Line 2081: l_error_type hr_lookups.meaning%type;

2077: l_estab_headcount_3112 number ;
2078: l_estab_salary_tax_code hr_organization_information.org_information3%TYPE ;
2079: l_assg_action_id number;
2080: l_value fnd_new_messages.message_text%type;
2081: l_error_type hr_lookups.meaning%type;
2082: l_error hr_lookups.meaning%type;
2083: l_warning hr_lookups.meaning%type;
2084: l_estab_location hr_all_organization_units.location_id%TYPE;
2085: l_location_name hr_locations_all_tl.location_code%TYPE;

Line 2082: l_error hr_lookups.meaning%type;

2078: l_estab_salary_tax_code hr_organization_information.org_information3%TYPE ;
2079: l_assg_action_id number;
2080: l_value fnd_new_messages.message_text%type;
2081: l_error_type hr_lookups.meaning%type;
2082: l_error hr_lookups.meaning%type;
2083: l_warning hr_lookups.meaning%type;
2084: l_estab_location hr_all_organization_units.location_id%TYPE;
2085: l_location_name hr_locations_all_tl.location_code%TYPE;
2086: l_name_comp hr_all_organization_units_tl.name%TYPE ;

Line 2083: l_warning hr_lookups.meaning%type;

2079: l_assg_action_id number;
2080: l_value fnd_new_messages.message_text%type;
2081: l_error_type hr_lookups.meaning%type;
2082: l_error hr_lookups.meaning%type;
2083: l_warning hr_lookups.meaning%type;
2084: l_estab_location hr_all_organization_units.location_id%TYPE;
2085: l_location_name hr_locations_all_tl.location_code%TYPE;
2086: l_name_comp hr_all_organization_units_tl.name%TYPE ;
2087: --